Excel automation project – smart workbooks + master dashboard

Hi,

I have a set of structured Excel workbooks already built. (there's 4 businesses in total each with 2 workbooks per a business that need to feed into each other and then a master)

I’m looking for an experienced Excel freelancer to help with:

Adding formulas and logic across multiple tabs
Creating calculated metrics and simple RAG (Green/Amber/Red) indicators
Applying clean formatting and dropdowns
Linking multiple workbooks together
Formatting dashboards that pulls data from those workbooks (each workbook needs a dashboard which then needs to feed into my master one)
Ensuring everything is stable and easy to refresh

Important:
The structure is already designed – no redesign required but if there are suggestions to make it better and more functional for my businesses that will be super helpful

This is an implementation task (logic + linking only)
Must be done in Excel (Power Query preferred but open to suggestions)

Deliverables:
Fully working Excel files with logic in place
Dashboard correctly pulling data
Simple instructions for updating / refreshing

I hope I am explaining this well - essentially I am trying to build a smarter system for my managers to use to make their jobs easier but still make sure data is captured properly.