Auto-generate new sheets with starting and ending date.

Registration date
Thursday October 27, 2016
Last seen
October 27, 2016
I started using macro in excel and I would like to inquire how to generate sheets by just giving the starting and ending dates. For example, I have the main(first) sheet saved as 'main' and on Column D5 and D6 of this sheet I have the starting and ending dates respectively . For example 1/05/2016 and 31/10/2016.

So I would like to generate 6 other sheets automatically i.e 1 for each month containing the days/dates of each month in columns in each of the sheet.

Can someone help?