Keeping a sheet of formulas relative to the workbook the sheet is pasted into

Hi,

I hadn't thought in this direction before. Instead of using a macro to generate a summary sheet of a workbook, what about using a ready-made sheet that keeps it's calculations relative to the workbook it's pasted into?

I get multi-sheet workbooks of data from programs I use. The programs I use call them 'reports', and so when I ask for a report I get them in Excel format - usually a multi-sheet workbook. As is usual, I want to make my own summaries with this data. My go-to solution is macros to create a sheet.

Let's assume my summaries are simple enough to complete with formulas. In other words, the complexities afforded by macros are not required - it's just the way I've been doing it. So, would I be able to move a sheet of formulas (my summary sheet) around to different workbooks and keep the sheet relative to whatever workbook I paste it into? I think sometimes this may be a simpler solution than macros.

Thanks.

Ugh. I was afraid of that - it keeps the link to the original book regardless of it's location.

Thanks