I have work instructions for a factory I'm putting in a spreadsheet. I print all the work instructions on a standard printer in portrait view. The worksheet typically has multiple pages stacked vertically. Each page consists of a header about an inch and half tall, which is the same throughout all pages, then the page is split into four equal quadrants with one line of text as a footer. Margins are minimal.
Each quad has a picture, a colored shape about 1/2" tall such as a triangle (inspect), square (work) or circle (verify) and then a number 1 thru 4 (text box) inside that shape depending on the quadrant. And finally each quad has text describing the work associated with the picture above it. Often we have to add a step after a page has been completed. I want to be able to highlight a quadrant, push a command button and then move that quadrant and all its contents along with all preceding quadrants, down one position in a "Z" pattern. This, so that I can insert a new instruction.

At work I have some code written that moves cells content down when highlighted and the button is pushed, but it doesn't include pictures or objects and no "Z" pattern movement. You also have to select empty rows below the cells so content isn't cut or erased.

One way that I have been able the cause is that I've added a button allowing the user to pull in pictures from folders and vb automatically sizes them and positions them starting at a preselected cell.

Some ideas or help would be greatly appreciated.