Pulling out data from different worksheet when changing a heading on the top-down list

Hi guys,

Please have a look at the sample excel file attached below so you get the idea of what I want to achieve here.

In the file attached below, you will notice that I have used VLOOKUP function in Table A to pull out data that meets certain criteria from Table B in 'Product A Index' tab.

Now, when I change the heading to the 'Product B' on the top-down list, I want the table A to use the data from 'Product B Index Tab', instead of pulling out data from 'Product A Index tab',
Its just so that I do not have to use separate tabs for each product lines.

Any help will be greatly appreacited.

Cheers,

HAPPY NEW YEAR TO YOU ALL!!!!!

Sample - Excel.xlsx

It works perfectly on my excel spreadsheet m8. Exactly how I wanted. Thanks heaps. Happy new year