Add data to 2007 table based on column names?

I have a data table which I update periodically (a couple of times a week)
from a report. My current process is:
* Run the report
* Convert the report output to a table
* Add a calculated column
* Copy each column one at a time and paste under the corresponding column in
my data table (values only)
* Use 'table tools', 'design', 'remove duplicates' to remove duplicates
based on 2 columns.

(The data from the report only contains a subset of the fields tracked, so
using the report only as a basis is not an option)

This works fine but is pretty tedious and I want to automate it. I could
use end(xlDown) to find the last row, add 1 and store that number, then copy
and paste my data based on that row number, but it seems kind of clunky. I'd
like to find a more elegant solution that could be adapted for various
situations such as importing another data table with the identical format but
different data, or if my source report changes (as it does occasionally).

It seems like there should be some sort of option to do a basic version of
this built in, but I haven't been able to find any such thing. I would be
very grateful if someone could point me in the right direction here.

Thanks,
Tara