Google Sheets Expert: Data Reconciliation & Advanced Formula Setup (1,000+ Rows)

I am looking for a Google Sheets pro to help organize and connect data across multiple tabs. I have a master list of approximately 1,000 order numbers that need to be populated with specific details (pricing, shipping, SKUs, etc.) currently stored in different sheets. Scope of Work: Data Matching: Use the unique Order Number to pull accurate data from various tabs into a master view. Formula Creation: Set up scalable formulas that handle 1,000+ rows without slowing down the sheet. Data Cleaning: Identify any discrepancies or missing values where an order number doesn't have a match. Technical Requirements: Advanced knowledge of VLOOKUP, INDEX/MATCH, and XLOOKUP. Experience with QUERY and FILTER functions is a plus. Ability to use ARRAYFORMULA so the sheet updates automatically as new orders are added.