Hi

Each day I will have an unspecified number of identical spreadsheet logs saved into a specific folder. I have a Master spreadsheet that I want to collect all the data to.

In all the other spreadsheets, the data the agents complete starts on Row 3, each row of data contains info from columns A to I but the number of rows will vary depending on how many calls an agent takes each day. If I need to give a figure, then I would choose 1000 as agents would need to be bionic to do more than that.

So can i get a macro in Master.xls to open all other files in the same folder and copy all the data from the other spreadsheets so that I have one very long list on my master sheet?

Thanks

Sir BD