Google Sheets

I run a small trucking company. All my data is tracked on Google Sheets. I have two particular spreadsheets I want to work on for this project - with several more less complicated spreadsheets needing to be done soon. The two spreadsheets are "2018 Broker Info" and "Oilfield Customers." Each of my drivers has a tab on the 2018 Spreadsheet (examples attached). Each time they pick up and deliver a load, the data from that load is entered into the "2018 Broker Info" spreadsheets. I want to be able to put in the Invoice # and or BOL # into "Oilfield Customers" spreadsheet and have it automatically import a range of data (column A-J) from the 2018 Broker Info spreadsheet. So once the data is put in to the 2018 Broker Info spreadsheet, all I have to do to import that data to the Oilfield Customer spreadsheet is to type in the Invoice number or BOL number. As if that is not complicated enough, I want to be able to extract that data from each tab (each driver tab) from the Broker info spreadsheet to the Oilfield Spreadsheet simply by the invoice or BOL #. For example. the 2 David tab. His invoices will be numbered 1DAV, 2DAV, 3DAV etc. The 5 Alex, his invoices will be 1AX, 2AX, and so on. So if I type in Invoice #12345A on the Oilfield spreadsheet I want it to pull that range of data from the 2018 Broker Info regardless of which driver's tab that invoice is came from. I need at least 15 tabs to cover all my drivers. Is that remotely possible? Please let me know. Thanks