I am necessarily (someone else's system) working with 12 plus different
workbooks which are badly formatted so that they can't be easily printed. So
I have created a 'sheet2' which has references to pick out the data I want,
arranged as I want it to print it.

However, when I copy one of these 'sheet2s' to another workbook, all of the
references e.g. =a1 have the reference to the first workbook e.g. =
[workbook1]Sheet1!A2

I am more than happy with the 'sheet1' part but don't want the [workbook1]
part as, of course, this won't work when I put it in [workbook2]!

Help please!

--
Regards

i4004