Depending on the result of a test - =IF(APR!H520,... I want to insert the
name of the sheet into a cell on another sheet and use it to automatically
insert the last day of the month in a cell.

E.g. on sheet APR, if H52 is greater than 0, the sheet CLAIM B10=APR.
Then if B10 =APR then B11 contains 30 April 06

Can this be done and if so can someone point me in the right direction please?

Cheers,
Lee