collect data from multiple files and sheets

Hello
I would like to request that I have multiple excel files and I want to copy all data from every sheet of each file into one Excel File (on one sheet)
each file contains the different number of sheets and also blank cells in data.

I want to append them to only on Main sheet of Master Data workbook. VBA code is the preference for this task.