Transposing blocks of cells
 

I have uniform blocks of cells across and down in a sheet and the number of
blocks are variable for each sheet. I would like to append each block to the
one before it on another sheet. The cells in each block differ in value. What
would be the code to do this?

Thank you

Dave