VBA - replace all data in a named range with data from a separate workbook

[Balest01]

Hi - I am looking for code that will copy data from one file and replace the data in a Named Range on a separate Excel file with this copied data. I need the Named Range to keep the same name so that the pivot tables that refer to the named ranges will continue to read from the same range. I know code for copying and pasting, the named range is throwing me off though. each day the number of rows will be different, sometimes more, sometimes less. Any ideas?

Thank you in advance!