Based on a user selection in a combo box, Is it possible to copy a range of cells from sheet1 and move them to sheet2??

I'm kinda lost as to how to tackle this?

Thanks, for any help I can get it.

Greatly Appreciate it!

I have a combo box that looks up a list with 29 objects through data validation. The combo box is filled from a sheet called 'Species list' with a range A2:A30. The combo box is located on a sheet called Step 2 in cell C5.

I would like the user to be able to select a specific object from that list and automatically copy whats in the cells on a sheet called 'dscombo'!C11:C20:G19 and paste the values from those cells into a sheet called 'Step 2'!C11:C20:G19.

The key point that I should make is that the range of cells to be copied and pasted will vary depending on what object is selected from my combo box.

In the range described above that I want copied and pasted, the user would have selected the first object from the list in my combo box.

I hope this helps explain my question.

Thanks