Thanks snb but this did not work for me. I don't know why but my tables do not dynamically adapt when additional data is copied into them. I tried it manually just to confirm before writing the code. Also, the SpecialCells method did not work on some previous tests as it kept telling me the first blank row in the table was the last row in the table. As for not declaring variables, that is a major error in my book since it leads to more problems than it fixes. That is why I use the Option Explicit in all my programs. I just had it commented out here while troubleshooting.
Appreciate you taking a look at this and providing some suggestions.