Like DocAElstein suggested. Explain in detail.
But also:
In "Sub UnmergeAllCells()" you reference ActiveSheet
In "Sub UnwrapTextAllCells()" you don't reference any sheet.
In "Sub PasteSpecial_ValuesOnly()" you reference 2 sheets (Sheet1 and Sheet2)
In "Sub RowAndColumnAutoFit()" you reference Sheet1
In "Sub deleteMultipleRows()" you again don't reference any sheet
In "Sub DeleteColumns()" you reference sheet1
Always reference properly. That gives you an advantage that code can be run from any sheet and still work as it was designed to do.
Your 6 little macros could be in one like below.
Change Sheet references where required as we don't know which sheets you're talking about.
Code:
Sub msiyab()
With Sheets("Sheet1")    '<---- Everything refers to Sheet1 except the first part of the "Sheet2" line. (Obvious I would say)
    .Cells.UnMerge    '<----- Do away with using merged cells. They give you guanranteed problems at one time or another
    .Cells.WrapText = False
    Sheets("Sheet2").Range("T2").Value = .Range("S2").Value
    .Columns("A:BF").AutoFit
    .Rows("3:6").Delete
    .Range("A:C,E:F,H:J,L:S,U:X,Z:AB,AD:AH,AJ:BF").EntireColumn.Delete
End With
End Sub
Now you have half the amout of lines plus you have the advantage that you can run the macro from any sheet you like.
And I don't think you need the "Reply With Quote" Just extra not needed clutter.