Good afternoon

I have a worksheet which when printed needs a date in cell G1. That's the
easy part...

What I am trying to achieve is that the user inputs a start date and an end
date and for each sheet printed the first has the start date in G1, the
second has G1+1 through to the end date excluding Saturdays and Sundays and
ideally other dates on an exception list e.g. Bank Holidays.

Hopefully that is clear but I am at a complete loss as to where to even
start so would really appreciate some help.

Many thanks

Kewa