Looking for some guidance on automating XLOOKUP across multiple tabs and columns please

[excelsiorsq]

I was basically working with XLOOKUP functions and I need to be able to pull data from two separate tabs. My goal is to automate this process as much as possible to avoid the need for all those manual adjustments with each XLOOKUP and reference cell change.

I have got:

• In Row 1, I'm using the formula =XLOOKUP(A6,'SALES VALUE 2022'!A6:A190,'SALES VALUE 2022'!D6:D190,"-",0)
• In Row 2, I'm using =XLOOKUP(A6,'SALES VALUE 2023'!A6:A155,'SALES VALUE 2023'!H6:H155,"-",0)
• In Row 3, I'm using =IFERROR((B6-C6)/C6,"")

These formulas are working well for now. However, I'd like to replicate them across all other columns that correspond to specific dates. The aim is to have the dashboard update automatically when new data is imported into the software-based tabs for 2022 and 2023.

Could anyone guide me on how to achieve this? Any help would be greatly appreciated!

Thank you so much in advance