Import Multiple Excel Work Sheets into Master excel file using VBA

Hi,

I am new to this forum. I am in need of help in importing excel files into master file automatically through VBA. Below is the scenario.

1) Currently, I have 23 stores P&L statements, which I export from Sage software every month, then I open them one by one and select the whole sheet and unmerge them.

2) I have master file. Once, I have unmerged all, I copy all those individual files into excel master file manually.

What I am looking to get a VBA code, through which, when I press the Import button in Master file. It open file browse window. From there when I select all the files from a particular location. It should copy all the individual sheets into the master file in separate Tabs and rename the tabs name as per the individual file name and then unmerge all the copied individual sheets.

I have searched the internet a lot and couldn't find any solution (VBA code).

I have shared the files for your reference (the individual file Before and after merging).

https://drive.google.com/open?id=163...XR95DjknF3Czli

I shall be very thankful in advance.