VBA to clear all date in columns A2 to AC in the destination file, then copy the data from the same columns from all files in a folder

[jdhfch]

Hi,

I am wanting to merge all the data from cells A to AC from all files in a folder into one worksheet. Row 1 has the headers on it, so it needs to start at row 2. Columns AD onwards are locked. I also dont want to have to dismiss any update popups etc.

I would like the user to be able to select the source folder location please.

Any help is appreciated.

 

[jdhfch]

Please can I ask if anyone can help me here?