link to diff workbook IF dates match

I have an excel spreadsheet with about 15 columns that is a list of students with their school name, start date and end date, SIN, Date, First Name, Last Name, Birth date, etc.

I have a different spreadsheet that has a separate tab for each month.

I would like a formula or macro or coding(and how to use it) that would take the date column from spreadsheet 1, and if the date is in the month of September, it will copy 4 of the columns from that row into spreadsheet 2 into tab "September". and the same if the date is in October it would copy into tab "October" in spreadsheet 2, and on and on.

The Main spreadsheet is a list of students, it is updated many times a day with new students, I am looking for a macro that when the second spreadsheet (2010 spreadsheet with tabs for each month) is opened you can run a macro that will search the main spreadsheet for SIN numbers that are not on spreadsheet 2, and add them to the appropriate tab in spreadsheet 2 (2010 spreadsheet with tabs for each month).

For example, If I open the main spreadsheet and add this studentSIN FN LS Start End School Entered111 222 333 Johnny Cash 09/01/2010 04/30/2011 GUAG 10/15/2010

when I save this new data and I open the 2nd spreadsheet (2010 spreadsheet with tabs for each month) and I run the macro it should see that the entered date is October, therefore it should pull this student's SIN, FirstName and LastName and plug it into the first empty cell (below all other copied data from previously running this macro) into the tab named "October".

The information on Computing.Net is the opinions of its users. Such
opinions may not be accurate and they are to be used at your own risk.
Computing.Net cannot verify the validity of the statements made on this
site. Computing.Net and Compnet Ventures, LLC hereby disclaim all responsibility
and liability for the content of Computing.Net and its accuracy.