Hello,
I have a workbook that has two worksheets, Data and Reports.
In both of them I have dynamic names setup to include all of the data needed
for the reports worksheet. Data connects to an external datasource to get
information and when there is new information it does appear in the Data
sheet but not in my reports sheet.

So Reports looks like this

A
bob
tom
sam

Because Data looks like this:
A
bob
tom
sam


But if I connect to the datasource to update everything and Data looks like
this:
A
bob
tom
sam
dick
jane

Reports will still look like this:
A
bob
tom
sam


How can I make it so that the new rows are added?


The dynamic name in Data is called "raw_names"
The dynamic name in Reports is called "new_names"
The A column in Reports has this formula "=raw_names"


I am not too sure what this is called and have had trouble finding anything
similar to this issue.

Thank you for your time and help.
Take care.