Two points ...

#1 : Do not use Merged Cells. Cells that are merged are extremely difficult to work with, if at all. More often than not merged cells will create more issues
than they solve. Please undo all of the merged cells and re-post your workbook.

#2 : What sheet is this data to be pasted to ? My initial thought was to create a new, empty sheet and paste the data there.