I am importing data into Excel. I need to have that data duplicated in a
worksheet of another workbook and have it updated when I open the workbook.
Is there a way to create a link or some other mechanism that will accomplish
this task?

Also, I need to create a dynamic cell reference. That is it refers to the
last column of the last row that contains data. This reference will change
as I add data to the worksheet. Thank you in advance for your assistance.