Perhaps a look at the following link to a similar thread back in early December may give you a guide to a possible solution. I believe that your query is similar. The Poster did not bother to reply so we cannot be totally sure if it worked for him.
In the above-mentioned thread, my post #2 has a code which should work for you also although you need to ignore lines 14 - 21 of that code (this part creates new named sheets which you won't need to do).
There is a DropBox link in the same post which shows how the code works.
Have a look and let us know what you think. If it suits, we should be able to sort something out for you.