Excel E-Commerce Pricing Reports

I need a clean, automated Excel workbook that turns raw supplier price lists into clear, detailed pricing reports for my online store. The file should let me drop in the latest supplier spreadsheet (CSV or XLSX), map the fields once, and then refresh to show:

• every product with its current supplier cost
• my pre-set markup or margin formula applied
• a ready-to-print/report tab that highlights price shifts since the previous update

Please keep everything inside Excel—no external macros that require additional installs—using Power Query, pivot tables, or VBA only if it makes the refresh seamless. I maintain the worksheets weekly, so the process must be straightforward: import, click refresh, and export the finished report as PDF when needed.

Deliverable: the working Excel file, clearly commented so I can adjust formulas or add new supplier columns later, plus a short walkthrough video or written guide showing the refresh steps.