I have a workbook with about 50 sheets of different country data with cells organized in identically in each sheet. I am attempting to use a combobox to select a country so you can get a snapshot on the dashboard. I am aware on how to build a similar dashboard when all the data is on one sheet, using combobox selection and index function. Do you guys have any advice for accomplishing this with multiple sheets?

Thanks,
Mike