Hi,

Please see the link below to my post in the General Excel Forum

http://www.excelforum.com/excel-gene...eadsheets.html

I have approximately 500+ workbooks which are growing in number on a weekly basis, I wont to be able to collate certain cells from each of the workbooks onto one master document and every time another workbook is added to the folder I can run the Master document and it will update.

I think I have the VBA to open each file and then close it again, but I need some guidance on how to copy the individual cells and then past them to the Master document in the correct place, then move down to the next row??