I've created a logsheet for employees that calculates the hours and
pay. The supervisor would like to know if it's possible that her
spreadsheet would be able to load all the total pays of her
subordinates and show the result without copying and pasting.

Currently the total is located in one cell of the spreadsheet. I wonder
if I can create a macro that reads the number of one specific cell of
all the files in one folder and use the file names as the employee
names?

Thanks for any pointer,

cpliu