I need a google sheets expert

Job ID: 34574494

Budget: $250 – $750 AUD

I have over 250 budgets for individual jobs in google sheets. I want to be able to create a master sheet that brings in live data from each individual budget. I would like to know the best way to try and achieve this