Creating New Excel Sheets from Master Sheet

I was wondering if there would be a way to input data to a master sheet and have it organize data on other sheets.

Specifically, I would like to be able to input a date of service, along with other data, and have it automatically add it to another sheet - by month.

I know there are easier ways to do this, but this particular way was requested and I am not exactly sure how to approach this.

Will your data set have a primary key (identifier)?