My boss was asking me to make a macro that could do something like this.

The workbook has 7 sheet's, each sheet is a report, sheet 1 is an x-ray
report, sheet 2 is an dyepen report etc etc. Every report has its own report
number (from report 1 to .....). My boss's problem is that different user's
use a report number that may have been used before. He want's me to make a
macro that controll the input on every report, thats not a problem.

My problem is that, in cell D5, the report number should +1 for every time a
report is made. Also, the first time its opened it should be 1 the second
time its opened it should be 2, and this only for the active sheet. Is this
possible?