Hello again, Greg, I've tested it. Wow, that will sure come handy when I get these frustrating documents. Thanks.
At first I got and error message, 5992, cause the Column Collection, are not the same size. Or something similar. I'm translating this from french.

I've realized some top few rows, are merge together. Like Two columns are for Quarter 4, next two column are for Quarter 3 and that is for Row 1. So I've tried to split the first row from the rest and your macros (1 table & All tables) Works

It would be challenging to find a way to tweak those top rows, cause from one table to another, I could have different number of Rows that have some merged columns.

Your Macros, made my Whole Week or Month. WOW, I'm always impressed by programming Pro's skills. CALL ME IMPRESSED

Thank you again soooo much.

Cendrinne