Copy and paste range in excel error

Hello all! So I'm trying to copy and paste a column of data (Column D in my case). It's about 7k rows long and I need to move it from one worksheet to another worksheet in the same workbook. I can't have the top row (it's a title) so I made a quick data item with the row # (minus 1). I keep getting the following error: : Failed to copy worksheet: Invalid index. (Exception from HRESULT: 0x8002000B (DISP_E_BADINDEX))

My hunch, after reading some of the previous posts is that it's my source and destination workbook. I've included a screen shot of the my properties. Any advice? I've also tried using .xls instead of .xlsx to no avail. I've also tried removing the spaces as well.

View attachment 1562635979761.png