Please forgive me if my question is not clear or this topic has already been discussed.
I have a custom workbook with 12 sheets (as an example), each representing a month. In each sheet there will be a value (in a cell) dollars for that month. In a given active sheet, I would like to capture this value from each previous 5 sheets(as a historical summary). Note : I only require the values from the previous 5 (as an example) sheets only. This will be dynamic. That is, if I am in sheet 3 it will only capture the previous 2. If I am in sheet 5 it will capture values from sheets 1 to 4, if I am in sheet 7 I need to capture the values from the 2 to 6. If I am in sheet 12, I need to capture values from sheets 6 to 10 and so on.
Your assistance will be much appreciated.
Gops