Need help autopopulating from master list

Hello,
I am building a budget and inventory tracking system for a landscape company. I have data that I import from a field service tracking software. I import as a csv file then copy the following columns: "Worker", "Location" and "Actual Time" at the job site and paste into the weekly sheet. I want to add a column named "Budgeted Time" next to "Actual Time" so I can quickly calculate if they spent to much time at the job.
My thought was to have a MASTER tab and list all the Locations in one column and all the respective Budgeted Times in another column, then have the Master feed or auto populate the budgeted time into the weekly sheets based on the corresponding column (i.e. Location) on the Master List.

Thank you so much for you help.
SD