Scroll Multiple Sheets to the Same Position Simultaneously

I am working on a project which requires a way to enable all of the sheets within a suite (about 8 separate sheets within the workbook) to scroll to the same position.

All sheets are set up with a list of products going down the page and what I would like to do is to be able to scroll to a specific product on the active sheet and when I toggle to one of the other sheets they will have scroll to this same position as well.

I am thinking that I will need to use a look up funstion to search for the product name. Any suggestion would be extremely appreciated.

Thanks in advance.

Barely tested

In a code module:

Please Login or Register  to view this content.

In the master sheet module:

Please Login or Register  to view this content.

In the ThisWorkbook module:

Please Login or Register  to view this content.

THANK YOU tremendously! Worked like a charm. I can't tell you how much the board has helped me. Hopefully I can progress to the point where I can help others like myself!

Thanks Again!

Thank you, Simon ; the OP liked one of our solutions ...

Remove this from the ThisWorkbook module:

Please Login or Register  to view this content.

And add this to the 'slave' worksheet modules:

Please Login or Register  to view this content.