Linking info from Tabs into LOOKUP using List

I once again require your assistance please.

What I would like to do is link certain information on a main tab to values (taken from lists) from other Tabs.

I will try to explain...
This is a quoting spreadsheet.

Tab 1 is the main page which in which you manually input Qty and Size. Material and Labour are chosen from lists which then pull in a m2 price using;
=VLOOKUP(B3,'General Prices'!A:C,2,FALSE)

The labour element is done in the same fashion but has a few more options (being Top, Left, Right and Bottom) each pulling a price from another Tab.
=VLOOKUP(D3,'General Prices'!G:H,2,FALSE)*CEILING(I3,500)/1000 - For Top
=VLOOKUP(F3,'General Prices'!J:K,2,FALSE)*CEILING(J3,500)/1000 - For Left
etc etc.

Now, is it possible to create new Tabs for different clients pricing structure that I can then automatically direct the main pricing document to by using a 'List' of clients?

Simply put...Main Pricing Sheet has a drop down list of 'Clients'. upon choosing a 'Client' all of the Vlookups direct to that Pricing Tab.

Does all this make any sense?

Thanks for any help you can give.

Tom

Thought it may help a little with a screen grab.

All prices are coming from 'General Tab'

I would like page to direct to prices from Client 1 'IF' 'Client 1' is selected in cell B1. Client 2 if client 2 is selected etc etc.

Thanks

Thanks for looking - I have uploaded my document which has a small description.
TOM_PricingDocument.xlsx
Thanks again.

Tom

Jete,

That looks exactly what I needed so will test fully.
Cannot thank you enough kind sir.
Have a wonderful day.

Tom



I will also now find out how to do it myself as well as assigning a list of tabs to a cell.