Sync multiple google sheets into one

Job ID: 30779669

Budget: $30 – $250 USD

Hey was wondering if you know how to attach multiple google sheets. I have multiple companies submitting google forms( leads) . The answers go to each companies spreadsheet and I share access with that company. I’m looking to have the answers sync into one spreadsheet for my team but when they make edits to the leads on this master spreadsheet I would need it to update on other sheet.(example: a sold leads row is turned green and marked as Approved into status column, I would need that update on the master spreadsheet to sync back to the other spreadsheets.
Related categories: Excel Google Sheets