You are looking at the problem the wrong way. You need to check before the copy and branch the process accordingly. First start with a list of what you have and what you want to end up with then look for a way to make it happen. Decide if each thing you want to happen is to be done as a separate process or if you want the whole list of things to happen in a single navagational tool?
You may build into your application a dash-board of individual controls or a single control with a menu for all the options.
The clipboard is not the best way to get things done in most cases, direct range work is generally a better way.
If you want to copy a sheet then ask the user to select a new sheet name or a destination and have your code complete it. If you want to copy a selected range then ask the user to select a destination or automatically select the destination based on how the overall application works.
As for, working with the clipboard, you can test indirectly, you can insert a temp sheet, paste the clipboard contents and test for patterns or characteristics such as the cell count. And, then branch the next steps depending upon what you want to happen. Then do the house cleaning and delete the temp sheet!