No that I've found, my workaround is to use a hidden config sheet with file paths/etc. There's probably a better way!
If you're just copying sheets, then no I don't think macros copy as well - you either need to save the whole workbook as a copy or copy individual macros across. Obvs make sure it's .xlsm to keep the macros!
I was approaching it wrong... in the end all I had to do was make a copy of the macros & pivots workbook and copy the other worksheets (no macros or pivots) across into that.
Will be trickier if ever there's macros in both workbooks, i found a tip to export & import these in this case.
No that I've found, my workaround is to use a hidden config sheet with file paths/etc. There's probably a better way!
If you're just copying sheets, then no I don't think macros copy as well - you either need to save the whole workbook as a copy or copy individual macros across. Obvs make sure it's .xlsm to keep the macros!