Hello, im sure someone will have a very simple solution for me

This will be very tricky to explain, i will do my best

Im working on many old files from excell, so in the new files, i set up 2 sheets, one for the data entry person and the other for me to only see what i really need, sheet 2 is only items that are copied from sheet one that i need to see.
So what i need to do with out copy and past to old files, but when i do that it is copy and pasting the curent file info instead of the old sheet 1 info

Example (i copied this from one file to another and it also pasted the file one info, instead of sheet 2 new file,
When pasting i want to get rid of the checkout blank.xls

='[Checkout Blank.xls]CHEKOUT5'!$B$3

Thanks for your help