need vba to pull data from another sheet based on cell input

Dear Friends,

On my Sheet 2, I have a data with below headings.

Referencenumber Customerdetails Currency Amount xxxx yyyyyy zzzzz aaaa bbbb cccc

On my Sheet 1, I need those above data to be captured based on the Input in a field C4

Note: All the above data in sheet one to appear in Columns (i.e. E4,E5,E6,E7,E8,E9,......) and also show this item in Red Color.

Another note: Sheet 2 will be having approximate 1,000,000 rows with above said headings.


Please help me with VBA macro and also to be faster after writing the C4 field.

Thanks

Dear

I have updated the required excel as a sample. Kindly support.

Dear

I have given the sample excel. Kindly support in providing solution.

Dear Arkadi,

I provided the required excel. Please help.

Thanks Samba Ravi.

I am getting if i write full 16 digits. But if i write the last 6 digit of 16, not getting data in F4 and below.

There is plenty of references, which we used to have last 6 digit of 16 digits or full 16 digits
Reference will never appear again in any of the rows.