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.