Can you save multiple files that link directly to specific, separate, sheets?

I work on a large master spreadsheet that contains information relevant to many different departments in my company. The workbook has separate sheets for each department. Is there a way that I can "save as" so that there are separate file icons in different folders on our shared drive that lead directly to each department's sheet?

For instance, if someone is in department X's folder on our company server's shared drive, and they see the file labeled "department X spreadsheet" they can click it and go directly to "department X sheet" on the master workbook, while someone in Department Y's folder can click on "department Y spreadsheet" and it goes directly to "Department Y sheet" on the master workbook. Would that be possible?

Automatically that is challenging but not impossible. Like anything it's all in the details of the implementation and your specific parameters.

What is probably your easiest option is to create a userform with buttons that take the users directly to their specific sheet. Then you can set the workbook open event to load the userform and ask what department the user is in. They will then click the button, and it will load their sheet directly.

Would this work for you?