That's a good point. I was thinking about the fact that they would each download as a separate workbook, but there's no reason I couldn't take the data from the differential workbook and put it as a sheet in the full workbook. That makes sense.

Follow up question: If the differential sheet also contains a new row that does not exist in the full worksheet (let's say a brand new course was created between the creation of the full data set and the differential data set), would a macro/VBA then be necessary to update the full workbook with that new row? I guess the long story short is, I'm looking for a way to use the differential sheet to update the full sheet so that the full sheet updates any existing values to match the differential sheet, and also adds any new values from the differential sheet that didn't exist before.

My goal here is to create an automatically updating Excel spreadsheet (the full worksheet) so that I can link that spreadsheet to an Access database, so that the database updates as well.

I am also brand new to databases, so if this is not the best way to go about the task, I would love any advice you might have.

Thank you!!