Hi there,
I don't know if this can be done using macro but if it's possible, please
help.

Is there a way to rename the sheet with whatever the content in cell A1? And
do the same thing each sheet in the workbook.
For example, if cell A1 for the first sheet has the word "Project" then that
sheet should be renamed it to "Project". If cell A1 for the second sheet has
the word "Time", then that sheet should be renamed it to "Time". And keep on
doing that for all the sheets in the workbook regardless of how many sheets
there are.

Thank you in advance. :)