I am preparing to merge sheets in a workbook, before I do I need to find a
way to pull the sheet name into ColumnX so once merged I will retain the
categorization.

Is there a simple formula I can paste/fill-down into a column to do this?

Thanks in advance