Hey all, I am managing a lot of information spread across three exccel documents (with multiple sheets in those documents). I am creating a master document that displays where I can find all the different types of information.

I was wondering if there was a way I could make a cell be able to link to a separate excel file. I have a list created that have the name of the 3 excel sheets, basically I would like the value of that list to be able to link to its corresponding excel doc.

For example:

List = Tom, Jerry, Eric

If I click on Tom, Tom.xls opens to the sheet with the information I need.

Is this doable?