How do I know which sheets are to the RIGHT and LEFT to the Active Sheet?

Hi,

Find the attached sheet with macros and QAT buttons to do as you now have explained.

Your last post implied you wanted to add a new worksheet after the last. That was new to the original question. I haven't included code to do this.