Excuse me for my poor english, but I am currently in some kind o
despreate situation here.

I am asked to create an invoicing utility of some sort by extractin
data from different spreadsheets in an excel file.

So right now I have an workbook that consist of 10 speadsheets eac
speadsheets represents a supplier and a chart showing all the model
they have along with the amount we charge them to ship pre unit and
sourcing speadsheet that consist of all the data (to make thing
easier)

What I want to do is create a new spreadsheet in the same work boo
that allows the used to choose:

1. A specific Supplier - (Used Data Validation)
2. 1 or more models in that worksheet (maybe some sort of dropbox tha
automaticaly shows the models of the supplier chose in the 1s
dropbox)
3. Which carrier it is using (VS or MP / LH)
If carrier = VS then it will show the charges in Cell AA, AB, AD and A
for the row of the model
If carrier = MP / LH the it will show the charges in Cell AA, AC, A
and AE for the row of the model

Please find the workbook I currently working with in the attachmen
below, any help will be highly appreciated.

Thank you in advance

+-------------------------------------------------------------------

+-------------------------------------------------------------------