I am trying to create a summary sheet that will look on certain worksheets based on on a cell.
For example:
If cell E1 equals 10-Oct-30 then it will pull data from tab 'End Oct 30'
I would prefer to use a formula for this calculations. to aid in another persons potential use. A custom function would be OK.