Insert cell value from other worksheets

[mas1]

Hi. I am creating a workbook with a dashboard. I need for specific cells in the dashboard to populate based on values in subsequent worksheets. What I need help with is the following:
The workbook consists of the dashboard and four tabs representing quarter one, quarter two, etc. I need the dashboard to reflect the latest entry, for example if a cell in quarter one is not null then replace the value in the dashboard with the value of that cell. If quarter two is not null then replace the same cell with the value in quarter two, etc.
I have tried IF, IF AND, and IF OR statements but I can't get beyond quarter two. When I extend the statement to include the value in quarter three, it gives an error.
Any help you can provide will be greatly appreciated.

 

[Z51]

While not pretty, something like this should work. It checks D1 on the 4th sheet (Quarter 4), then the third, second and first sheets.

=IF(Sheet4!D1<>"",Sheet4!D1,IF(Sheet3!D1<>"",Sheet3!D1,IF(Sheet2!D1<>"",Sheet2!D1,IF(Sheet1!D1<>"",Sheet1!D1,""))))

 

[mas1]

Thank you very much. It works. I was making it more complicated than necessary.

 

[mas1]

Thank you for the reply. It works great. Now, I have another question. I need to replace 0 with "-" without changing the currency format or the formulas in the cells. Thanks in advance for your recommendations.

 

[Z51]

As it's unrelated to your original question, post it as a new question in the forum.