Insert current date into cell based on another cell true / false across workbook sheets

Hi guys,

​Need help with the formula below.

What I need it to do is search through the workbook sheets (2-101) and check on each sheet if cell "D1" shows a result of TRUE or FALSE. If it is TRUE, then I need the formula to change the contents of cell "E6" on that sheet to read the current date (DD/MM/YYYY format). If it is FALSE, then I need the formula to go onto the next sheet and search for TRUE or FALSE and so on, all the way to sheet 101.

Thanks guys.

Here's the code I currently have:

Please Login or Register  to view this content.

Hi ProtonLeah,

That done the trick, thank you!