Check out this Google blog post detailing how to combine data from two Google Sheets in four steps.

https://blog.google/products/g-suite/g-suite-pro-tips-how-sync-one-spreadsheet-another-google-sheets/