Merge multiple sheets data into one worksheet based on multiple criteria and date

Thanks for your response.

The requirement is typing but if can be possible can we make both calendar and typing.

At last the script will read the textbox dates of period and extract the data right.