Is there a way to make a reference to a worksheet tab dynamic? In other words if I have tabs named summary, Jan, Feb and Mar
On summary tab I want to reference cells in Jan, Feb or Mar. but I want reference to look to a column heading in summary tab to determine what other tab to go find data. By changing column heading I want to look to a different tab for result.
Can anyone help?