Instead of copy/pasting the tab, you should copy/paste the cells in
the tab to overwrite the previous days' values.

Hope this helps.

Pete

On Jan 10, 3:47*pm, Jonathan
wrote:
Hi all,

I have developed a worksheet that I would like to use on a daily basis to
pull numbers from a file that comes out with an updated version each day. *I
would like to use the same spreadsheet (by either copying and pasting the tab
into the updated s/s or pasting the updated tab into a template) each day to
pull the updated data each day. *The tab name stays the same as "Raw Data"
each day, but when I try to link it, it doesn't work and it still looks for
the original spreadsheet I used rather than just updating the numbers by
changing the data. *Thanks.