Thanks for your reply ThePower777 - That code does work, but there is a little hiccup for me - I should have included a better example sheet.

This updated one shows my problem, there is a formula cell in the middle of the range that does not need to be copied (it aggregates the cells above it), so that when the data is imported your way - plus one row at a time, it overwrites that cell, and isn't in the correct location. See attached file. Saving File Example.xlsm