I have 18 employees, which each have monthly 12 files for timecards. Each
file is identical in it's format. The difference is each file then has 4-5
worksheets, one for each week and totals at the bottom for hours worked and a
description of the project they were working on each line.

I'm trying to put together a database to replace this archiac way of doing
their timecards so that it will total the hours worked on a specific project
using an Acccess template (Time & Billing).

However, my first step it to get all of this data into 1 report per
employee, so I can import (or rekey if I have to) the information into the
database.

Any help is greatly appreciated!