Copy from different sheets- data based on selection and paste rows in new sheet

Hi all,
I have 6 sheets.
Sheet 1 to 5 has data.
In column 1 I have date & in column 2 have names on each sheet.

Last sheet is called 'Report'

I am trying to do the following:
On Report sheet I have a text box to type date of report required and also combobox to select Name

- I select either name or date ( Only one selection)
-Then all data rows matching selection are copied From Sheets 1 to 5 and pasted in sequence one below the other in report sheet
-The headings also are copied
-between two data range ( say from sheet1 ... sheet2)... one row needs to be blank to demarcate.

I am exhausted as I have tried many combinations and it is not working.
Very challenging indeed

Any help or thought process please

kind regards

Hi Stnkynts,
Thanks for your prompt reply.
This method is great than what I was trying to do.
It does copy data and is fine
However ( I deleted data on report sheet to try again)
- In subsequent attempts it pastes much below the row A2 on report sheet
-Date function does not work
-It does not copy heading (i.e. Row A1 of each sheet)

Need to consider the following please:
-It first clears data on report sheet
-It copies Row A1 first and then data of each sheet
- Pastes data starting from row A2 on report sheet every time
We are almost there....
Thanks again
Kind regards

However ( I deleted data on report sheet to try again)

You didn't delete the data. You probably just cleared the contents of column B since you were scrolled over to the right by 1 column. Make sure you clear the dates out of column A too.

-Date function does not work

Yes it does. I just have it set to only allow one parameter because of what you said here:

- I select either name or date ( Only one selection)

so if you want to copy by date you will need to remove the name.

-It does not copy heading (i.e. Row A1 of each sheet)

That is correct it does not. See amended code below for the addition of row 1

Please Login or Register  to view this content.

Hi Stnkynts,
Really many thanks for your help.
It does work fine now.
Thanks for your tips, as it seems that I may have made few errors earlier.
Very well done.
Thanks again.
Kind regards