Well Hi to every one and thanks in advance for the help.
I am trying to join the information from several work books together while keeping each an individule collection. I have a Main workbook that has many clients names and profiles listed. From that Main I want to be able to click in a cell and have it mean to move to a different workbook (say the medical workbook). I can currently do that however, I would like to go to a specific page in the work book for just that one client. What I currently get is the whole workbook no control over the page.
This way I could start with a client in the main and go all the way thru seeing all the information for that client or I can start in just the medical file and update each clients care in only that file. It, of course, would then updated from either direction.
The frustration is caused by not being able to select the individual worksheet to be the result of the jump from the main worksheet cell.