Please forgive me if this is a bit basic, but wouldn't it be easier to
just keep one master file and do pivot tables to calculate daily and
weekly totals quickly when you need reports?

If you have then a standard format that you use for reporting you could
dump the data files into a template or macro to format the reports the
way you want.

Just a question/suggestion if you haven't thought of it.

PZan


--
PokerZan
------------------------------------------------------------------------
PokerZan's Profile: http://www.excelforum.com/member.php...o&userid=23480
View this thread: http://www.excelforum.com/showthread...hreadid=376688