Copy formula to reference next worksheet

I have attached a file for reference.

I would like to be able to grab the bottom right corner of cell B2, and drag down the B column. The automatic fill would put in the names of the many sheets in the spreadsheet. When I add another sheet, I would be able to automatically fill in the new sheet's name in the next cell down in column B.

This comes from an excellent formula that fills in all the other cells data based on the information from Column B. Now I am looking for a way to automatically fill the cells in Column B.

Please see the attached file for a better explanation.

Thank you all very much for your help!
--Seth