I will do excel automation with macros, vba and google apps script

Both, and the answer usually depends on who else needs to open it. Excel with VBA when it lives on one machine and handles volume. Google Sheets with Apps Script when several people use it or it needs to run on a schedule without anyone opening it.

Yes, and it is often faster than rebuilding. Send it and I will tell you what is broken, whether the formulas are salvageable, and where the actual fault is. Sometimes it is not the spreadsheet, it is the export feeding it, and I will say so.

That is the difference between a template and a one-off fix. Ranges are dynamic, formulas expand, and pivots and charts pick up new rows without anyone editing a reference. I test it with a second month of data before delivery.

In Google Sheets, yes: Apps Script runs on a timer, generates the output and sends it, with no one opening the file. In Excel it needs something to trigger it, either Task Scheduler on a machine that stays on, or Power Automate if you have it.

For VBA, yes, and the file has to be saved as .xlsm. If your organisation blocks macros, which many now do, say so upfront and I will build it in Power Query and formulas instead, or in Sheets. Finding out after delivery helps nobody.

Yes, and it is what Premium is for. Source data goes in one sheet, the dashboard reads from it, and nothing needs rebuilding. Charts, slicers, and a refresh that either runs on a button or on a schedule depending on the platform.

Then this is the wrong gig and I will tell you before you order. Past roughly 50,000 rows, or wherever it starts hanging on open, the work belongs in Python. I have a separate gig for that and it will cost less than fighting the spreadsheet.

Yes, in writing, in the file. Named ranges, a notes tab covering what each part does, and comments in the VBA or Apps Script. The test is whether someone who has never met me can change a column next year without breaking it.

Yes: an API, a database, or another tool, pulling live rather than pasting. Small integrations fit here. If the sheet is really a staging area for a proper pipeline, my data pipeline gig is the better answer and I will say so before you order.

Send the sheet and describe what should happen without you. One repeated task is Basic. A template that several people use every month is Standard. A dashboard that refreshes itself is Premium. I will tell you which, or quote a custom offer.