Hi,

I have Files saved weekly in the same location as the master BSF file.
I am looking to pull the data from the relevant saved file in the same Folder based on the Tab name in the master BSF file

I.E MD79 23.08.2021 tab - Will match a file saved as that file name, copy all data on that sheet1 and copy back to master BSF file

Looking to build up the data week on week by populating the data but without having to copy and paste each week if possible
image1.JPG