macro for user input then copy cells from worksheet and paste into another worksheet

Hi,

I am planning to put a button to run the macro on the 'Summary' Tab.

I would like the macro to prompt the user to Input a 'name' - which could include a number, then based on the 'name', the address information from other fields be populated to the summary worksheet.

I have attached workbooks for clarification.

Eg. 'Name' 'Mike1' is found in cell 'A4' on worksheet 'Data Source'
Values to be copied from Cells 'A4' - 'D4' worksheet 'Data Source' and pasted into worksheet 'Summary' into cells 'C3 - C6'

Any assistance to write this macro I appreciate!

With Thanks

Penn

Wow... thanks. That macro worked exactly right.

If you are happy to assist me further, I have another purpose that I would like to use this macro for and that's for if the 'Summary' worksheet was in a separate workbook to the 'Data Source' worksheet.

Name of the workbooks are
'Address' and 'Data Source'
Results will display on Sheet 1 of the 'Address' Workbook.
Only the 'Address' workbook will be open when I run the Macro.
The path of the Data Source Workbook is 'H:\MyDocuments\Macro'
Thanks