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

Many thanks in advance

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

On Nov 11, 11:25*am, Consu wrote:
That when I paste the worksheet with references to different workbooks it
always make reference to the same worksheet.

Many thanks in advance