As I use a macro or VBA to accomplish a procedure, I need to be able to “Capture” which sheet I came from in order to return to that sheet and grab more info.
How do I track this info? I essentially need the Sheet number “Dropped off” someplace so I can use it later.
I plan on using 

Sheets(Range("B2").Value).Select

as the way to get back to the sheet from whence I came, but how do I capture the sheet number of where I came from?

Thanks!