Copy cells based on filtering and paste it to another excel with sheet reference

[arijitirf]

Hi!
In my excel, there are 3 columns like Date, Req. No. & Qty. Now I want to filter the date column based on month through inputbox and copy the filtered cells to an another excel with sheet reference.

For example, If I put "01" as month in inputbox then it will search through all sheets and filter like this

Sheet 1: Date Req. No. Qty.
16-01-2018 349 18
26-01-2018 378 153
Sheet 5: 12-01-2018 340 890
19-01-2018 365 332

And this entire result will be copied in a new excel sheet or a new workbook.

Help required.

Thanks in advance.

 

[arijitirf]

Help required