Can't figure it out

[mitchlortie]

I have been beating my head against this for months and can't seem to get anywhere.

I have a workbook with multiple sheets. Each sheet has a pre-defined grid of 8 columns, 4 for labels and 4 for values (label column, value column, label column, value column, rinse lather reapeat...). I have a new, empty, preformatted workbook every day of the month generated nightly automatically from a master template. The issue I'm having is as follows:

If a row is added to the sheets say the 15th of the month, the workbook tables from the first 14 days of the month are now out of alignment with the last 16 days of the month due to the new line addition.

How can I use a macro to scan each workbook and sheet within each workbook to see if all cells match for placement and if they don't figure out where the line(s) was (were) added and modify the preceding sheets accordingly so that all cells DO align properly?

It's a tall order I know but I,ve reached my wits end. Any help or suggestions are greatly appreciated.