dynamic hyper link to link to matching sheet

[supermanjohn01]

I need a dynamic link that is created from a concatenate that will find the concatenate combination from another sheet. For instance, I have 6 sheets. Sheets 1-5 each have two spaces, of which I will list cities, a beginning location in cell A2, and a ending location in cell B2. These will create a concatenate on the sheet I have typed this information. On the Link page, in cell A4 and B4, I will type in this same information of a beginning location and an ending location These two will ALSO create a concatenate on this sheet, but at the same time, will create a link to the sheet that has the same concatenate combination, no matter which of the other 5 sheets this appears on.

 

[felixstraube]

What is going to be in sheet 1-4? Do you need a hyperlink that takes you to the first cell in the A column in the linked sheet? What version of excel do you have? Why not keep all you data from sheet 1 to 5 in one sheet?