Hi there
I receive a report, that contains different sheets in a workbook. The sheets are namned year-week, for example: "w0732". Some of the cells in this weekly sheet I have to copy into a new workbook. I would like this to be done automatically, but the thing is that the report will not be updated every week, only for a week now and then. The name on the sheets between W801 and W0805, can be "W0802", "W0804", "W0805", etc...

Is there any possible way for me to ask my workbook to automatically copy the next sheet in that workbook without knowing which week it will be but take the name of the sheet and print it into my workbook?

Also, sometimes there is a sheet for one week, but no indatat, so I want to skip those sheets (weeks).

Let me know if its not clear!

BR Susanneh