Wrapping cell data to a new column or page in Excel

[candimc]

Ok, I have something that I don't think can be done but I thought I'd
throw it out here to see. I have a workbook that consists of multiple
sheets. Each sheet has 2 rows of header data, 24 columns and 78
additional rows of specfic data (81 rows in all).

Once you ignore the 3 header rows the data looks something like this:

ClmnA ClmnB ClmnC ClmnD
ClmnE ClmnF
1st Street A Ave
Stcode BLK GRID Stcode
BLK GRID
3rd Street B Ave
Stcode BLK GRID Stcode
BLK GRID

Here's what I'd like to do. Let's say I realized that I had missed an
entry (each entry being 3 columns and 2 rows worth of data) for 2nd
Street. If I inserted two rows of 3 column cells about 3rd street, I
would like the 3 columns and 2 rows of data that moved down to wrap
up to the top of the next set of columns (D-F). When the data got
below the very last row available (row 81) I would like it to wrap to
the top of the next worksheet (row 4 actually to leave the header rows
intact) and then have the process repeat until all sheets are updated
to only 24 columns and 81 rows.

Any help anyone could give would be most appreciated. Thanks!

 

[candimc]

On Jan 11, 4:25 pm, (e-mail address removed) wrote:
Correction on part of this, there are 3 rows of header data and not 2
as described.