Dear Experts

Is there a way to compile all the name of each worksheet tabs on one spreadsheet e.g.

A1 = Sheet1 (name of)
A2 = Sheet2 (name of)
etc...

Many thanks in advance!