VBA to copy data into other sheets based on specific criteria’s

[humacdeep]

Hello,
I need your help in preparing a Dash Board. I have an excel file with data pulled from external source & have lot of dump in it. I am looking for specific data that need to be pulled from that dump and saved in another sheet of the same file (as in example file).

In the Received Sheet:
1. It should prompt for the date and after entering the date (21- Jan in example file) it should fetch the data of Team A to Team E and paste it in Received Sheet based on Column L (Insert_time).
2. If this sheet is not available it should create a new one, if the sheet is already available then it need to clear the old data and paste the new one.

In the Closed Sheet:
1. It should prompt for the date and after entering the date (21- Jan in example file) it should fetch the data of Team A to Team E and paste it in Closed Sheet based on Column N (Close_Time) & Column U (Status of only “Closed”, “Closure Pending”, “Verified Closed”)
2. If this sheet is not available it should create a new one, if the sheet is already available then it need to clear the old data and paste the new one.

In Open Sheet:
1. It should fetch the data of Team A to Team E based on Column U (Status of only “Open”, “New”, “pending”)

I have attached the sample spread sheet for your reference. Sorry if my request is not clear.

Thanks in advance for your help!!

Regards,
Humac