1. I would like to be able to automatically create a hyperlink that connects the names in column B of the "Students" sheet to the matching tab names in the workbook. (I have a separate TOC that functions well, but the "Students" sheet has more info on it that needs to stay grouped by row.)

2. Similar to above - I have a button on each sheet for each student that I would like to connect to an outside Word document. The Word doc will have the exact same name as the sheet and also the exact same name as the student listed in Column B of the "Students" sheet (as above). It seems ideal to have a macro that runs when the button is pressed to seek out the matching Word Doc, which will all be kept in the same file. So on the "SANTA CLAUSE" sheet, the button needs a macro that will automatically open the "SANTA CLAUSE" word document.

(I tried attaching the file, I guess its too big?)

Thanks in advance if you can help.