Hi. New user on the forum. I'm working on some spreadsheets for tracking sales data at work. I have one worksheet which tracks overall numbers by salesman initials. I have another sheet that tracks individual sales. On the second sheet, each salesman has their own worksheet, one for every month. Example, employee AXK has 12 worksheets in the individual sales file: SEP-AXK, OCT-AXK, NOV-AXK, DEC-AXK, etc. What I want to do is, in the first file, the overall numbers tracker, I want to change their initials on each month to a hyperlink that opens their worksheet in the other file directly. The most I've managed is to turn it into a hyperlink to open the other file, but it opens to the last opened page. I haven't been able to specify what worksheet to open to directly. Any and all help would be greatly appreciated.

Thanks.