Excel Magic Trick 417: Get Last Value from Multiple Sheets
Download Files:
https://people.highline.edu/mgirvin/Y...
See how to get the last value in Column B from across many sheets using the LOOKUP and INDIRECT functions. This is from a post at the Mr Excel Message Board.