Data Validation Drop Down (Select)

Hi,

 

I have a question about data validation. When you have the traditional data validation where you click it and have a drop down, I was wondering if you can have this format, but when you select one of the options from the drop down, you can be transported to a page within the spreadsheet?

 

For example, say if I had a drop down data validation with a list of cars such as Nissan/Fiat/Hyundai/Porsche/Ferrari etc... and I click on Hyundai as my selection, can I then be taken to a worksheet within the workbook with that page containing all my Hyundai information?

 

This might not make sense but I hope it does!

 

Kind Regards

 

Steven