Replacing imported tables while maintaining formula on other sheets

Hi All,

Looking for some assistance with a problem I have encountered while trying to improve my excel work.

So, I have an excel workbook [original] which is presented poorly. I have made a new workbook [new] with the data displayed how I want it. I have imported the original workbook into the new one and am using the =XLOOKUP formula to pull data from the original sheet to the new one.

The problem I am facing is that the original workbook is published every month and I need to pull the data from the original to the new one.

When I try and Import the original book for a new month with the same name I get the #REF error on all my formula, presumably because the imported data has changed.

What I am looking for is a way to maintain the formula in the new workbook so I can just import the original sheet every month and it will pull through.

Any help with this is hugely appreciated.

Thanks
Connor