is this possible? - Create new sheets based on dates submitted in macro

So this is something Im not sure how to do at all or if its even possible to create and name sheets this way through VBA based on how my sheets are formatted.

If you look at the attached file you see 4 sheets. I will talk about them based on sheet number instead of name since those are long.

Lets say in sheet 1, we are filling out the form and clicking the add request button. Then the information is either pasted in sheet 2 or 3, depending on whether the values exist in the sheet 2 list or not.

So for what I want to know is possible is based on the column H of sheet 2. If whenever we run the "add data" macro, if the corresponding brokers are indeed entitled, and it says "YES" in column H, is it possible to create a new sheet based on the date submitted, all the info for the rows under the YES.

If that is confusing to understand, is it possible to create Sheet 4 based on the info I have updated in sheet 1. new Sheets should be created for each day, so if there are 5 different days information is feeding, a sheet should be created and named based on those dates inputted in B3.

What do you guys think? Is this too much?

Oh, one clarification. If lets say the macro "add request" is run, and the date is listed as June 27 in B3. If there is already a sheet with "June 27" on it, then no need to create a new sheet, and also no need to copy over information with the rows with "YES" if it is already copied over to June 27, dont want any repeats with either, just want to paste new values, and create new sheets when one doesnt already exist for the date needed