How can I populate col A with the tab name in a spreadsheet

I have a spreadsheet with 9 identical tabs. The only thing differentiating the tabs is the tab name.

I am looking for some help with a macrto that will insert a new col in A and populate the col with the tab name all the way to the end of the data and then move to tab 2 and do the same until all 9 tabs are done.

I have tried a couple of crude methods but this is above my Macro experience level.

Thank you in advance.

Ken