Run through list with file locations copy data back to main workbook

Hi all,

Been a long time reader - I've found many solutions here, but haven't been able to find one for my current dilemma.

I have a table with the full path and file name of all the files I manage (using power query). In each file there is a sheet called "COMPLIANCE". I need a code to run through the column, open each file and copy the information from the COMPLIANCE sheet and paste it back in my original workbook.

I had luck with this code I found online (probably here to be honest) - but can only do one file at a time. I really need to be able to run through the complete list of files without having to select. I've attached an example of what the workbook looks like

Any Ideas?

Please Login or Register  to view this content.

Works perfectly!

Thank you so much for this. This will save me so much time - not to mention the time saved trying to figure out how to get this working!

I've been trying to only copy specific rows with this code - with no luck. I may have lost hair over it. I tried filtering the data - but the workbook is locked and i was getting pretty inconsistent results.

Is there a way for each workbook that opens to find a specific date in column B and copy those rows only? I've attached an example of the Compliance sheet.