Macro to copy and past data from one worksheet to another

[hsingh2088]

I want to create a macro that copies data from one worksheet to another, but there is a caveat. I need to past the information in specific cells, correlating to a specific button, which correlates to specific rows. For example, I have 5 buttons (1, 2, 3, 4, 5) that I have created, and one field which takes data entry. I want to be able to click each button, and then as a result, I want each button to populate columns 1, 2, 3, 4, 5 of a different workbook, skipping certain rows, and filling in others. How do I do this?

 

[bubbapost]

Can you post an example workbook?

 

[hsingh2088]

How do I do that?