Multiple Price Tiers for Excel Estimate.. HELP!

Hi there. I am trying to do something VERY simple but for the life of me cannot accomplish it.

I create detailed manufacturing estimates in Excel to send out to customers. The estimate has about 200 line items on the "main" page, and there are 4 pricing tiers, depending on the type of customer we sell to: i.e. Tier 1, Tier 2, Tier 3 and Tier 4. Pricing for all 4 tiers is listed in a separate "work" sheet in the same document.

I would like to add a drop-down menu on the "main" page (Tier 1, Tier 2, Tier 3 or Tier 4). When selecting a tier, the prices on the "main" page must automatically pull the corresponding price from the "work" sheet.

A very basic example is attached. Please can someone assist? Many thanks.

Example_justinrmjc.xlsx

Put in C4 (main page) and copied down

=INDEX('WORK SHEET'!$B$8:$E$13,MATCH(A4,'WORK SHEET'!$A$8:$A$13,0),MATCH($C$2,'WORK SHEET'!$B$6:$E$6,0))

Check the file