So here's the situation:

I have multiple versions of the same spreadsheet-- each one has the exact same row and column labels.

The difference between any two given spreadsheets is that data in one spreadsheet shouldn't be in the other (but sometimes it might.)

Is there anyway to merge all of them into a "master copy" (or just a blank version) of the spreadsheet? (basically, using the data from various versions of that worksheet to fill out the main one)

Copy-pasting is extremely tedious, and doesn't allow me to copy blocks of rows IF the row numbering is non-contiguous. (For example, Rows 1, 2, 3, 6 are in a block, but row 4 and 5 just don't exist.)

Ideas? Googling hasn't turned up anything that seemed directly relevant to this problem.