Help needed with vlookup

Hi,

I hope someone out there can help!

I need to keep attendance records for my classes in Excel2007. Currently I download a new list every week into excel and mark which members attend. Then I copy this data into a master list in order to keep record of attendances over the duration of the course (8 weeks in total)

However as my list of members is constantly changing the weekly lists differ from the master list. I then have to go through the names individually and enter the new additions this is proving very time consuming!

Is there a way that the existing data on the master list can be exported automatically into the weekly lists? I've been experimenting with the vlookup formula but cant seem to find exactly what I need!

Any help would be appreciated.

Cheers,

Adam