Hi ranniellm77sez, welcome to Thunkable! 
Be sure to check out our posts about How to ask Great Questions v2.0, our Community Guidelines, and our Docs as you get started.
Our Data Viewers do not really work this way–they are merely meant as an easy way to viewing data.The best suggestion I can think of here is to have two data viewers. One that uses sheet 1 from your data source and one that uses sheet 2 from your data source. When you click on the button, you could then change the visibility of the data source so that only the second data source is showing.
Interactions and updating the data via click events works best with cloning, we have some examples here in our Thunkable Deep Dive: Clone Blocks