Compile Worksheets :


if you have data in same format on multiple worksheets and you want to compile on a single sheets you can Use this Macro, Sub ConsolidateAllSheets()         Dim wksConsolidate      As Worksheet     Dim wksSheet            As Worksheet     Dim lngLastRow          As Long     Set wksConsolidate = ThisWorkbook.Worksheets.Add     lngLastRow = 1     Application.DisplayAlerts = False    …