Workbook Connections, creating a copy of a tab

[Shovell242]

Hi guys,

I have a problem with my workbook connections duplicating as i create a copy of the most current tab into a new tab.

I have data that is pulling from access into specified cells of my worksheet. Each day i'm trying to keep my connections to the current tab, but then make the old tab lose the connection and just have static values. This may be REALLY vague but i'd really appreciate it if anyone had any ideas! Thanks!