What's the simplest way to copy data from another workbook
 

Thanks in advance for your time...
I have budget workbook with a worksheet that has employee hours. I want to
get these hours from a different workbook. Each employee has their own
workbook where they enter the hours worked. I want that data to appear in
separate workbook. I am creating this on a networked share where all these
different workbooks preside (are saved to).
I thought you could do it by copying from one workbook to another with them
both open... But that didn't work and I know how to do it on the same box:
=('E:\05Payroll\[AllTimecards.xls]Jenna'!B2)
Here are the particulars: PC name = BossBox, Share name = 05Payroll (BossBox
E:\ZyCor\05Payroll)
Employee workbook = Jenna.xls cell to refernce = B2
Thanks!