Dashboard header sheets and pivot tables - creating a drop down data selector box to drive the dashboard

[rlodge5]

I'm creating a set of pivot table reports in Excel 2007 with a separate reporting dashboard sheet where I want to have a drop down selector for a specific field - supplier name which will drive all the pivot table reports on a the separate sheet and hence update the charts linked on the dashboard front sheet - any help with doing this would be much appreciated,
thanks Richard

 

[SteveO59L]

use vlookup() on the result of your dropdown

 

[rlodge5]

Thanks Steve059L
how would that work? Is vlookup not just returning a set of data which is similar?
I need a drop down box on the dashboard sheet where my report output is which filters all the underlying report pivot tables