the first thing I always saw wrong was this code:
PATH is not declared. did you noticed that? furthermore, you are literalizing it. the way you're doing it, it should be a dir path, not just PATH. unless you're wanting to capture the ENVIRON variable, which I doubt.
ok, so I ran the macro recorder for the task that you are missing. it literally was 2 lines on a test:
thus....this is what you want, right? and, see images below....
the only thing that still doesn't make sense is this:
you can't have more than one sheet in an XL book with the same name for obvious reasons. the indexing by excel would get confused, not to mention raising a conflict of interest.
that code is just a modification of your last block posted. try it and see what happens. change the literals to make it work for you. first though, manually create a new book like I did. the result of my test can be seen in image 3 below:
Bookmarks