Reference Data in External Workbook
 

I'm trying to build a Payroll Workbook for a peice rate pay schedule. What I
currently have is a workbook that takes daily piece rate information and
calculates an invoice. The filename changes each pay or billing period. One
of the tabs in this workbook contains all of the work completed by each
employee. I'll reference this workbook as "Invoice".

What I'd like to do is create a seperate workbook where the payroll
department can import the "Invoice" Tab I need with the employee work. The
problem I'm having is trying to figure out how to build a pull down menu to
select the proper "Invoice" workbook. The Tab name is always the same. In
addition, I want to make sure that when I import the information, it's
values only.

I'm not sure if this is a formula function, or whether I would have to build
a macro somehow. Seems like I should be able to create a button that would
bring up a file directory, but I can't seem to figure this out. Any help
would be great!

Thanks for your time...