Button to display text; each time it is hit, display next in row

[passedpawns]

Hello Everyone!

I have a list of ID's in cell A1 - A50 on 'Sheet 1'. I have a summary page on 'Sheet 2'. I have a button on Sheet 2 that I want to pull the value in A1. When it is hit again, it shows A2. Again, A3 etc.

Please let me know how this can be accomplished! Thank you!

 

[V_Malkoti]

Thanks Joe!