title: Having a sheet that contains buttons for macros that run off of selections
body: <p>Is it possible to use <code>Selection</code> to define data used in a macro button that is in another sheet.  </p>
  
  <p>I'm trying to make a template workbook that's first sheet is a bunch of macro buttons.  I want to be able to select data in another sheet, click my button sheet, and click my button to run a macro on the data I have selected in the other sheet.  </p>
  
  <p>The problem that I'm running into is that sheets seem to have independent selections at the same time.  So my macro always runs on the selection from the button sheet instead of the sheet I was on.  Any thoughts on how I can make this work?  The selection of the data needs to be dynamic, so I can't just say .Cells(1,1).value because it might not be the data I need.  </p>