Excel VBA Proficiency: Google Cut n Paste.

I currently have macro which opens multiple Workbooks into different Worksheets in one Workbook. The workbook contains a master sheet, called DoNotDelete.
DoNotDelete is a template of all the other worksheets, which sums the values from all the worksheets, and displays the totals. Originally the non master worksheets all had the same format, and the macro was fine. Now there seems to be a tendency for some reports to occasionally have more rows or columns.

I am attempting to google something together that will loop through all the worksheets, obtain the worksheet that has the highest row count, and then manipulate all the other sheets to match the layout of the sheet with the max row count. This is all compared against column A in all sheets, starting at A3, generally ending before A80, there are null fields within the range Ie) If max row count sheet has a value in A40 equal to “Legal”, which ever other sheets do not have this value, will have a row inserted at A40 with the value “Legal” added. Repeat for all values from A3 till end.

I’m also attempting to do this on the Columns.

So far I have butchered code together that appears to loop through all Worksheets, and all cells in the A range, starting from A3.

Please Login or Register  to view this content.
What would I use to compare the various worksheets and format accordingly?
And would I be able to do something like find the max row count from all the Worksheets?

The number of worksheets open will be randomly from 2 to a max of 32

Thanks
Kez