Put each employees in cells A1 to A18
each month in cells B1 to B12

loop through thus
for i = 1 to 18
for j = 1 to 12
open filename Range("A" & i) & Range("B" & j)
ignore if sheet 5 not present
copy sheets 1 to 5
close this file
next j
next i

you have one big file with all 18 of them please

"Barb" wrote:

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!