Excel 2003 - Trying to merge multiple caseworker notes, saved in different directories into a master

[TimWallder]

I have a number of staff recording there case notes on individual workbooks in their named folder.
Labels along the top =
Client ID (number)
Date (date)
Action (Text)
Staff (Text)

Basically they complete this everytime they work with a client to keep notes. I want to be able to merge each persons notes into one master workbook.
I want the notes they have done to stay in their workbook.

Is there some macro or vba code to do this easily rather than copy and paste at the end of each week?

I tried to follow a guide using consolidate but it gave me a message no data to consolidate. Maybe i did it wrong.

Well thanks in advance for any help.
Tim

 

[VoG]

If you can get all of the files into one folder then Merge data from all workbooks in a folder (2) may help you.