Vba code to copy unique email id data from input sheet to output sheet

Hi excel guru,

Need your help!

From input sheet from column D i want unique id in output sheet in column D and also in reference to these unique id i want Name,City,Mobile number from input sheet to output sheet in column E i want count of email and in column F Minimum budget and in Column G Maximum budget and in H column bedroom and in I column Locality
i require all unique locality in one cell and also i require all unique Project in one cell.

Please find the attached file for your reference.

Thanks