Duplicate query not updating

Hi there,

I have connected to SQL to get a table of around 1000 rows.

I then used PowerQuery to duplicate the source data in to 10 queries and filtered each so I can have 10 tabs in Excel showing relevant data.

However, when I make a change to the SQL database, only the initial table is updated.

Is there a way in which all versions of the source data can be updated when a refresh is performed?

Any help with this is greatly appreciated.

Thanks,
Greg