Price List Template

Here is a very simple example, using some of your data as a base, roprice806 

You'll see that I turned your Pricing Sheet into a single database and then used it as the source for some DGET queries on the Bid sheet.

I put some notations on the Bid sheet that begin to suggest things you would need to do to make this more fully functional. I am assuming that what you sent was not complete, so you may already have some of those things in mind. But very definitely, what's needed to make the DGET (and other database functions) work is a single coherent and comprehensive database with prices at whatever granular level you will need for backing up your bids. If what I've done as a start raises questions, as well it might, feel free to come back with those questions.

By the way, I did not use (in fact I disabled upon opening) whatever macro you have written in this workbook.... I am a believer for the most part in letting Excel's own functions do the work; but it's possible that they're necessary in your setting.