Theoretical Excel dilemma

[beadmaker]

Hey everyone,
I have a problem, it's probably something really simple but I'm just not seeing it.

An unknown number of time sheets are coming in from off-site staff.
I have a copy of the time sheet template.
The column headings are :
Date ...... Task ......... Start Time ...... End Time ........ Hours.

The hours are totalled at the bottom.

Now, onto my dilemma.
I have to create a consolidation template.
All time sheets are to be imported into the template to work out individual fortnightly pay and the total gross pay for the pay period.

All of the possible solutions to this scenario that I've looked at seem to require information that I don't have.
ie: workbook names, sheet names etc.

This is a template, I have zero information.

What am I missing ?
Any suggestions ?

Any help you can offer would be greatly appreciated.

Thanks.

 

[bstory84]

Well you will only need to know the names of sheets or workbooks to reference them if you will be using formulas.

When you Say "Sheets" Do you meen multiple Excel Worksheets? Or multiple Excel Workbooks. or 1 continueous Sheets will lots of data sets?

I'm sure with more detail myself and or others will be able to help.
If you can manage to post the Template We can better assist you.

 

[beadmaker]

Thanks for jumping in.
Sorry about the lack of information, I'm kind of lost with excel.
I am also having trouble getting an image on here (seriously not my week).

This is the only way you might be able to take a look at the timesheet template. Sorry about that.

I hid some of the rows to make it more manageable.

http://i1079.photobucket.com/albums/w506/beadmaker1/excelpic.jpg

All of the timesheets will be identical to that one.
All of timesheets will be saved to the same folder -C:\Users\User\Documents\Timesheets

Next, I have a consolidation template it's an
Excel workbook named - Finance.
Anything about this template can be changed (it's a work in progress) except the name.

What I want / need to do (and I don't know if it's even possible) is to pull information from all files in the Timesheets folder and create a summary sheet in Finance workbook.

The data I need to bring across is:
Name, Employee ID, Total Hours.
I'd prefer if these were columns A,B and C respectively and start at row 8 if possible.


These would be followed by D (hourly rate) and E (gross pay).
D has an = formula and E has an * formula.

Grand Total is currently at E29 with an =SUM formula but as I said that can be changed if necessary.

So, what do you think ?

Do-able ?

(shoot, sorry about the essay).

 

[bstory84]

yes this is possible but will probably be a bit tedious.
Questions.
Will each employee have a single worksheet or Workbook? Or will the Worksheets have multiple employee records?