Excel Cost Sheet Consolidation

I need a clean, well-structured Excel workbook that shows our full cost picture at a glance. The main sheet should pull in two data sources—current supplier quotations and our latest internal financial reports—and calculate consolidated figures for each supplier. Key elements I must see in the file: • Expenses captured line-by-line, mapped to the appropriate supplier. • Automatic Profit/Loss computation for every supplier and an overall total. • Clear supplier-based layout (this is the primary way I want to navigate the data). Please link all calculations so I can update source numbers without breaking formulas, and use straightforward Excel functions (SUMIFS, INDEX/MATCH or XLOOKUP, pivot tables where helpful). Deliver the finished workbook plus any supporting import sheets you create so I can trace how each figure is produced.