Excel: Macro to copy selected cells from Worksheet to a specified Worksheet(s)

Hello everybody, my first message here. My problem is as mentioned in a title.

I want to copy selected cells from one Worksheet to a specified Worksheet(s) or to next Worksheet.

Rules:
1. After selecting the cells I press a button or a shortcut to execute the macro.
2. Inputbox pops up asking me the name(s) of the worksheet(s) where I want to copy selected cells. (or just copy to activesheet.next....)
3. Cells are copied to the assigned worksheet(s) to the exact same location as where the cells were in a worksheet from where the cells were copied.

Seems simple, but I'm a rookie with macros, I tried to solve this by recording macros but that led me nowhere.

Thank you for your help.

Regards, Hermanni Hänninen, Finland

Thank you, that did the trick.

Now I would only need a small code to be able to copy to several worksheets. I managed to change you code so that return from inputbox is string, so I can use workbook name.

So If I want to copy to several worksheets from inputbox output have to do some Case-Loop think?

Like if inputbox output is: sheet1, sheet2, sheet5
and I want to copy to all of those. First I think have to cut the string to smaller pieces, like separate every sheet name. And then do a Case loop?

Am I on a right track?

And is it too much to ask someone to do small coding for me?

Regards, Hermanni