This code works really great it solved my problems...
"you know an except is coming",
it does not bring any font or interior cell colors when it merges the worksheets.

How can the font and interior colors be added to this merge? I am out of ideas...