Need to create a drop-down menu that lists ALL the sheets on a SEPARATE workbook.

I found a walk-through on how to list all my sheets in a column, even how to link to them. But this method only works for the active workbook.

I have three workbooks and my idea/project is this:
1. Job Offer workbook
2. Employee Master List Workbook
3. Detailed Employee Roster

I would like my Job offer workbook to pull data from BOTH the master list and the detailed roster for information like: Current payrate, job ID(#), last 4 of SSN...etc.

So on the job offer workbook, I'd like my (very basic) employees to be able to drop down a list and show the different detailed roster jobs. Once selected, it would fill the job offer details about that specific job #. (location, dates, client name, etc.) And then another dropdown to choose the employee we're issuing a job offer to. It SEEMS simple in my mind, but it's hard to phrase in a Google search.

I should add that I'm OK with Excel, I've got 0 experience with VBA however.