insertable dynamic window problem

[Archaimot]

I want to be able to click a button on one sheet and have a large selection from a referenced sheet in the same book appear and be interactive. If I were to click a second button, I'd want a similarly sized selection from a different sheet to appear, and so on and so forth. I am so sure there's a way to do this, but I'm relatively new to excel programming and am teaching myself, but it's touch and go.

I'd deeply appreciate any help y'all can provide.

[natefarm]

Not sure what you mean by "appear and be interactive". Appear where?