Power Query Merge Issue - Duplicate Tables After Refresh?

Hi everyone,

I have two Excel sheets, each containing a table. I’m using Power Query to merge them into a new table (Merge query), and everything works fine initially.

However, after I load the result back into Excel, I notice something odd:

The merged sheet (called "Merge") is created correctly.

But the original two sheets seem to get duplicated again as separate tables (like "Table1" and "Table2").

My main concern is this:

I regularly update the data in the original two sheets.

So my questions are:

Will the merged query automatically reflect updates from the original sheets when I refresh and where to but the new data in the orginal sheets or the new table 1 and table 2?

Or do I need to set up something specific to make sure the merge stays updated?

Also, is it normal for Power Query to create duplicate tables when loading, or am I doing something wrong?

Any clarification would really help. Thanks!