Macro to Copy a range from one sheet and sellect where to paste in another sheet

Well I was able to accomplish my goal with 4 macros and 4 selection buttons.
See the attached Example.
I would still like to accomplish this with a selection mesagebox routine or a single button / macro seeing the first destination full and moving to the second and so on till it can paste values.

So I have done some work on this and found a reasonable Dropdown Box Solution to select the apropriate macro to run.

The only problem is that with the dropdown box located on the "Blank" sheet, the dropdown box name changes on the "Next" sheet when "NewNext" macro is run and renaming the first "Next" sheet and adding another "Next" sheet then requires changing the "Dropdown Box 2" identifier in the "DropDown_Change" Macro.

I supose I could move the New Next Sheet Button and the Macro Selection Dropdown Box to a different sheet and fix that problem. The 5 button system worked on the copied sheet without problem too.

I have attached the revision and the code should be in the VB of the workbook.

***Edit***

I ended up just moving the New Next Sheet button and the Drop Down box to the Calculation sheet and will use the workbook that way till a more elegant method comes about.