In a previous thread, the self naming dated macro tab works like a charm. Its been super easy to generate data every day but now I am having difficulty coming up with a formula or macro to have the summary tab automatically update with the new tabs. I need the same cells from each new tab. Copying and pasting links is one way, I've attempted and failed with trying to DEFINING NAMES and am stuck.
Basically, in the attached file, I need the # Error from each newly dated tab to self populate on the summary tab and include the date. The locations are the same cells on all the tabs.
Hopefully this is easy for someone with more experience than me.
Thanks MP
Bookmarks