Copy and paste values

essentialy a database IS what I am creating.

Yes, each job will have a seperate workbook and linked from the main(database) spreadsheet via a hyperlink.

Column A contains the booking reference which is how I would refer to jobs(click on the hyperlink opens up the workbook for that job) whilst the job is still live a lot of the cells in that row would have vlookups in them etc to get the job status and various information off the seperate job workbooks. Then once the job is closed off I run a macro from the seperate worksheet that does a copy and paste values, and the way it will know which row to update would be the booking reference which is also stored in the seperate workbook as well as column A of the "database"

If I left the vlookups *live* after a few hundred jobs have been completed i would imagine this "database" workbook would be horrendous to work with.

Ta
James