Adding mulitple spreadsheet data ranges to a column

This is where my code is failing and I know it's the syntax, but I'm not sure what to change. I've searched all over and found various types of syntax, but none seem to work. I'm sure it's likely something simple, but I'm not seeing it. I want it to search for the last used cell in the column, go to the next empty cell in the column, and put the selected range of data into it. I have multiple spreadsheets to search through that will keep adding to it ("i" is cycling through them).

Please Login or Register  to view this content.

I get 424 and 1004 errors (depending on how I tweak the line).

Thank you!

Try something like this:

Please Login or Register  to view this content.

Hmmmm... JBeaucaire, you bring up a good point. I had originally created this for a copy from a range of cells to another on one spreadsheet, but adding the multiples this doesn't work. Basically, I'll have "i" number of spreadsheets. Every spreadsheet will have data starting at column S4 to an unknown point (which is why I had originally put a static range on it knowing it would never be past 2000). I need to copy/paste that data into the "Cutsheets" worksheet and then continue pasting where it left off.