How can I make fixed a reference to a worksheet?

[Consu]

That when I paste the worksheet with references to different workbooks it
always make reference to the same worksheet.

Many thanks in advance

 

[Pete_UK]

You need to include the full path (if the workbook file is not open)
and the filename before the sheet name, like this:

='full_path[filename.xls]Sheet1'!A1

Note the apostrophes - allows you to have spaces in any of those
names.

Hope this helps.

Pete