Hi
So I have loads of different workbooks with Identical format and sheet names but different data, all located in one folder. I want to compile the important data in a master worksheet. The data i'm looking for will be in the same location and sheets in every workbook.
Can someone please...