Hey everyone, i am a new poster and was looking for any ideas about the problem i am facing. I am using excel for monthly accounting reports but cannot seem to devise a way to make them more and more automated. The problem is that when all the sheets are linked they move folders every month and new reporting locations are added on a random basis so formulas and sheets constantly need to be updated.

Does anyone have any suggestions on how to help automate these processes? Any help would be appreciated.

Thanks, Troy