excel - Adding data from master spreadsheet to other spreadsheets based on specific criteria? -

i have thirteen spreadsheets in workbook, first spreadsheet master schedule contains table column headers: "location", "equipment", "make/model", "serial #" , "calibration due date". twelve other spreadsheets have tables these same column headers, each 1 corresponding different months.

when enter data row in master schedule, want data automatically entered 1 of twelve other spreadsheets based on "calibration due date". example, if enter row of data in master schedule contains calibration due date of 01/16/15, want row of data inserted table in january spreadsheet.

i wrote formula in each of monthly spreadsheets causes data entered master schedule automatically entered spreadsheet, set filter 'calibration due date" column january january spreadsheet , did same rest of months, however, when new data added master schedule, row of data entered every spreadsheet instead of single spreadsheet corresponding date, filters on spreadsheets don't work on new data gets added.

how can row of data entered master schedule automatically entered 1 other spreadsheet based on "calibration due date" month?

the approach seem aiming may require vba, though question not tagged way (and if , don't post code risk downvotes , close votes). alternative create subsidiary sheets on demand drilling down pivottable. though require data added directly subsidiary sheets considered disposable.