I created a worksheet/spreadsheet with functions and references to cells in other worksheets/spreadsheets within same workbook to create a report of other worksheets within the same workbook.

I have lots of workbooks/spreadsheets on which I have to copy this worksheet lots of workbook, but I when I copy the worksheet to another workbook, excel create references to the workbook where I copied from.

Does anyone know how to avoid excel doing this?

Any help would be very much appreciated.

Regards