Hi

I have a workbook with many worksheets(over 10).I created a new worksheet in which I want to read the last cell value of each worksheet so i need a formula that reads the last cell value in Sheet1,the last cell value in sheet2...

any help?
thanks