I have a workbook with multiple worksheets, each with data in them. What I want
to do is select the UsedRange in each worksheet, copy it, and then paste it into
a different worksheet. With each loop through each subsequent worksheet, I want
to paste the current copied data at the bottom of where the previous worksheet
paste ended. All worksheets have the same number of columns, but can be a
different number of rows.

To add to my problem, on some worksheets there are a few extraneous cells of
data a few rows below the end row of what I want to copy & paste. Therefore,
simply selecting the UsedRange won't always work - I have to select all rows &
columns until I reach a row in column A that is blank.

I haven't even started writing any code for this piece of the project yet, so I
have no example to post. If somebody could give me just a few snippets of code
I think I could build from there. The biggest part of this would be to just
select the main rows & columns down to the first blank row, and I think I could
take it from there.