How to find staff assessments Date during a given Month?

Having trawled for hours on the web for a solution, I now turn to this forum for an answer, which may not even be possible. So here is the challenge:
I have thirty staff, each has a separate spreadsheet with various information contained on it, part of that information is regarding assessment dates and when each member of staff is due to be assessed. The problem is I'd like to create a cover spreadsheet where each staff member is listed in column 'A' and the next 24 columns represent a month followed by a blank column to be filled when the assessment has been completed, like so:
Column A = Name
Column B = Jan
Column C = check
Column D = Feb
Column E = check ...and so on.

Is there anyway excel can read each employees separate spreadsheet and then insert the day (date) his/her assessment is due in the correct month column of the cover sheet? So employee Dave is due an assessment on 5th May and another one on 5th November, can excel fill in the cover sheet to show 5 in column May and 5 in column Nov against Dave's name.

Each member of staff will have different assessment days. The objective of the cover sheet is simply to allow me to instantly see how many staff require assessments during a given month, and on what dates, so I can quickly determine my work schedule and diary. I would rather have this information all contained within the same workbook than having to keep switching between Outlooks Calendar and Excel.

Any help would be greatly appreciated.

Hi,

Welcome to the Forum.

So you have given us a challenge, can you give us a model workbook with sample data (insensitive, of course) to work with?

Your post does not comply with Rule 1 of our Forum RULES. Your post title should accurately and concisely describe your problem, not your anticipated solution.

Use terms appropriate to a Google search. Poor thread titles, like Please Help, Urgent, Need Help, Formula Problem, Code Problem, and Need Advice will be addressed according to the OP's experience in the forum: If you have less than 10 posts, expect (and respond to) a request to change your thread title. If you have 10 or more posts, expect your post to be locked, so you can start a new thread with an appropriate title.

To change a Title on your post, click EDIT then Go Advanced and change your title, if 2 days have passed ask a moderator to do it for you.

(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)