Copy & Paste a range after matching a input value with a column

Dear Friends,

I request a macro do do the following:

1) Take input in a dialog box
2) As per that input, check & match with values in a column
3) select & copy the data
4) paste it from next to last value in a column

I have attached a sample file in which I gave sample data and details of How & What to do.

I request experts for their support.