Automatically adds number of rows at page break which are deleted due to #REF! error

Hi,
( Please refer to attached file for clear understanding....)
When the commandbutton1 is used to remove #REF! error, all the rows shift up.
This affects badly on to the other cells , their purpose size , references etc. I also can not place remaining pages in that sheet on the side of first table due to too many complications.

I have count function ( green) which counts number of rows having #REF! error.

I am looking for a VB code which will count number of #REF! rows being deleted ( by press of a command button1) and adds those many rows just below the last row in that page ( as shown in red).

Is it possible?

Sheet1 code is as follows

Please Login or Register  to view this content.

Sheet3 ( command button code is as follows)

Please Login or Register  to view this content.

Any help will be appreciated
Many thanks