Select All Sheets and then change the Cell containing the dates


Sherees wrote:

I created payslips in excel which totalled to more than 50 sheets, each
employees pay slip is in one sheet. Now every month I want to change payslip
date and payment period dates in each sheet. what is the easiest way to do
this work? can this work be recorded in macro and be done by a click of a
button?