Searching & Displaying data

Hello there,

I have got two worksheets. One that has got the data and one that displays the reports.

A,B,C,D is data one (I am only going to need A,B & D)
F,G,H is data two.

First of all I would like to join B&A in report sheet with a space so I will have Name Surname.

Then I would like to bring up all values from column D that matching to B&A(if Surname Name is repetitive just bring it as one) name
but as one and bring it to the report sheet in column B.

After that I would like all the values of D that has been matched and displayed in column B (report sheet) with the name from B,A to check if they match with column F and if they do bring the values of column H in report sheet in column C.

Finally in report sheet create an interactive button(or something) with the name Start Report and once that pressed run the macro.

I have attached a sample of the spreadsheet where it has been explained thorough and in report sheet I have type how it would look. (the data i quite big containing approx 30.000 records (a,b,c,d) and approx 2000 records (F,G,H).

Many thanks and I hope I have come to the right section this time.


Kind Regards