Hi,
This is a bit of a weird one so please bear with me!!!!!!!!!!

I want to create an excel workbook that is full of references from other workbooks. The data will obviously change as it is updated. Is there a way to make the workbook where all the data is collated to stop updating when you save it? Basically I want to 'save as' the workbook under a different name and take a snapshot of the data in the other wookbooks!

I hope I have explained myself well enough.

I just need to know if its possible and if so how

hopefully

Gaz