Google Sheets Inventory Automation

I keep all of my inventory records in Google Sheets and now I need that file to do the work on its own. Using Apps Script you will build a single, well-structured spreadsheet that:

• pulls new inventory figures into the correct tabs without manual data entry
• runs the calculations I already use—stock on hand, reorder points, valuation—every time the sheet updates
• produces a clean, printable report (PDF and formatted sheet tab) at the click of a button

Everything must stay inside the Google workspace, so no external software connections are required; the script just needs to interlink the different sheets I use and orchestrate the workflow automatically.

I will consider the job complete when:
• the script is fully commented and lives inside the spreadsheet
• I can add or edit a raw data row and see all calculated fields and the generated report update instantly
• no manual triggers or add-ons are needed—only Apps Script bound to the file.

Share the finished spreadsheet and the script code with edit access so I can test on real inventory data.