No experience, special copy and paste column macro

Hi,

I have zero experience in VBA macro. There's a worksheet that I'm working on that requires many steps and I was wondering if it's possible to combine it into a single macro.

1. Copy and paste column B through G starting starting at row 2 and paste into a new worksheet in a single column.
2. After the data is in a new worksheet, I would also like for it Sort that column from A through Z
3. Then insert a new row to give a column a header name called "Description"
4. Then do a subtotal count function on that column

I'm not sure if it's possible but any help would be appreciated. I've included the excel sheet and thank you so much in advance!