sum multiple worksheets from multiple workbooks to ONE master workbook worksheets

Hi everyone,

I have 15 workbooks in a folder and could be more in future. Each workbook have atleast 7 different worksheet (named: worksheet_A, worksheet_B, worksheet_C etc...)

I would like to create a master workbook using where it can summarize/pull data from all the15 workbooks. The master workbook contains 7 different worksheet with the same worksheet names.

All workbooks including the Master workbook have the same kind of worksheet.
For example: Worksheet_A has 5 columns ( f_name, l_name, product, quantity, price)

Master workbook will act like the summary for all the 7 worksheet. It will calculate/sum up all the price for me in their respective worksheet.

I hope I have explained it correctly. Sorry if this is confusing.

Also, keep in mind that all 15 workbooks names could be different and can change.

How do I go about doing this? Please help me someone.