Referencing another sheet cell by the criteria of another cell.

Hi

I have some test scripts which are comprised of a summary page with links to the separate tabs and an outcome field.

The scripts themselves are step by step instructions in table format with a data validation list in column D "Incomplete, Pass, Fail or unable to test.

If the script fails we put the details of the failure in column F.

What I'm wanting is; If column D contains "Fail" display the text in column F on the summary page.

Quite complicated I know and I'm not even sure if it can be done.

Could anyone help please?