Copying date from one sheet to another button

[Granpa01]

Hello

I'm trying to create an inventory using excel.

I need help in creating a button that would copy the text in sheet1 from cell B1 - B5 then pasting to sheet2. I would like it to copy several times and each time I press the button, paste it on the next free cell below in sheet2.

Thank you for helping.

 

[Zot]

Explain about copying several times. Are you copying from same location?