Simple Google Sheets Automation

We want your help in: Automating simple formulas in Google Sheets, Pulling numbers from other Google sheets into a consolidated Sheet, and configuring a Data Dump tab to feed into inputs from other tabs. More detailed briefing to come once freelancer confirmed