I have the macro below that works well, the only issue is a format part that only works for one sheet. The text in orange works well, the text in red doesn't which I think is weird considering their the same except for the name of the tab.
HTML Code:
Bookmarks