My boss had me create a spreadsheet to track Letters of Intent to Purchase specific glass types from three different vendors to guarantee pricing for our customers before a price increase goes into effect. The first sheet lists all the customer and job names in Column A & B respectively and then subsequent columns would list various glass types and the square footage of each used in that particular job.
What I want to do is then to have the data automatically sent to the correct vendor table. To clarify, the first sheet/table lists the jobs and the glass from all three vendors are possible choices. I want the other tables to list all the glass for that specific Vendor. Each job could possibly show up on all the vendor-specific tables depending on what they ordered for their job.
I have included a sample version of the data.