Dear Client,
I can create this data sheet for your reference. I believe you also want this to be automated. For example when you add new data to any of the 11 excel files the main file should auto update, am I right? if so I can do this job for you within 1 day.
do let me know if you are interested in working with me on this.