create list from data on multiple sheets

Hi,

I am not an IT and I really really need help.

I have data contained in matching cells from several sheets. I need a worksheet that reflect the summary of the data from the worksheets. No formula is required. I just want my summary worksheet to list the all the data from my other worksheets. I might end up having about a hundred worksheets that I need included in the summary. Attached is a sample.

It would be better if the summary automaticaaly updates as new worksheets are added.

Thank you.