Spreadsheet Formatting & Lookup Formula Updates

I have a set of existing spreadsheets that need two things: cleaner, more consistent formatting and refreshed lookup formulas. On the formatting side, I want cell styles, number formats, and overall layout tightened up so everything is intuitive at a glance. Then, within those same sheets, the current lookup logic has become brittle after several rounds of edits; I need every VLOOKUP, HLOOKUP, and INDEX-MATCH reviewed, corrected, or rebuilt so the data they pull remains accurate even when new rows or columns are added.

Once you’re done, I’d like a brief summary of the changes you made so we know exactly where to look if further tweaks are required.

"I HAVE A SAMPLE OF THE FILES THE NEW FILES SHOULD REPLICATE."