Merging Multiple Spreasheets into One Workbook

[Donal28]

Hi All

I have 5 different spreasheets called 8100.xlxs, 8200.xlxs, 8500.xlxs, 8520.xlxs and 8510.xlxs which each have 4 to 5 within each one, I want to merge all these into one workbook. The files are located at

C:\Users\Mccarron_D\Desktop\Fairview_Compliance


Any help on this would be very much apprecaited

Regards
Donal

 

[VoG]

This may help you http://msdn.microsoft.com/en-us/library/cc837974.aspx

 

[Donal28]

This may help you http://msdn.microsoft.com/en-us/library/cc837974.aspx

Thanks for the reply VOG, I ended up putting the different sheet into on workbook by using the move and move or copy command