MULTI SHEET- populate a cell in results sheet with last entry from previous sheets

Hi,

I am trying to get a cell, lets say A2, on Sheet 5 of my log to be equal to the last non blank or greater than zero entry in cell A2 from Sheet 1 through Sheet 4.

Example: sheet 1 cell A2 = 5, sheet 2 cell A2 = 1, sheet 3 cell A2 = 3, sheet 4 cell A2 = blank.

The value I want in cell A2 of sheet 5 is 3. Any help would be greatly appreciated.

The value I want in cell A2 of sheet 5 is 3

Since that value, per your example, comes from sheet3!A2, what is the criteria that this cell value should be used rather than, say, sheet1!A2, which = 5.

You need to provide a more explicit explanation and the criteria/logic for deciding which sheet/cell gets priority.

Originally Posted by Palmetto

Since that value, per your example, comes from sheet3!A2, what is the criteria that this cell value should be used rather than, say, sheet1!A2, which = 5.

You need to provide a more explicit explanation and the criteria/logic for deciding which sheet/cell gets priority.

In my example the cell A2 in sheet five would have the value of 3 because 3 would be the last non-blank and greater than zero entry of the sheets (sheets 1 thru 4). I'm trying to keep tract of an account by month. Each month has it's own sheet (Jan thru Dec). The value each month could go up or down so I want the latest months value in my results sheet. In my example sheet five would be my results sheet. I going to try to attach an example log to this if I can. I hope that made more sense. Thanks for the help.