I need a macro that bring data from 3 possible worksheets (Wk sheet A,B
& C),in each worksheet there are 10 product lines which are reported in
8 regions (columns B to J).

I was hoping the macro would work be driven by the 3 possible scenarios
for users to pull data from. at the moment I have a drop down menu with
1st one being the 3 possible worksheets. 2nd drop down being the 8
regions and the last being the 10 product lines.

Now comes the question,if someone want's to select e.g. wk.sheet 2 and
region column B (the information will come from the wk.sheet selected
i.e wk. sheet 2). and the last drop down selected is product z.(info
will come from wksheet 2)

is there a way this can run via a code in the background to bring all
this in one wk.sheet.