Sorry it took so long, I have been busy.

You might take a look here to get an idea of how to work with shapes.

www.rondebruin.nl/controlsobjectsworksheet.htm

The code  I sent doesn't care how many worksheets  are in the workbook  or what
their names  are. When it is run, it will work on every sheet  unless code is
added to skip other sheets.

The code I gave you was as requested using cell addresses. If this is the way
your document is set up then you will need to insert code for every shape. If
there is a way you can set the shapes  in the same cells  as where it will be
pasted in the other sheet, then you can copy shapes and paste them all in one
code line. If all shapes are copied, without calling a shape name, it is very
quick.

If you are using cell locations and shape names, then turn on your Macro
Recorder and it will record your moves. Send me the code and I will clean it up
for you.