I need to create a database that links to other workbooks or files? For example:
I have a list of named projects with a few detail fields in the highest level.
When I click on a project name, I'd like a list to appear.
When I choose from the list, I want to be taken to the associated file or different workbook that has tabs with more detail on each project.

For example at the highest level:
A1: Project Name--A2: beginning date--A3: ending date--A4: status notes
Each project name linking to associated file/workbook in a dropdown list:
Project details
Funder profile
Funding type
Program Division
Project Lead

Can someone tell me how to do this?