Greetings,
I have a macro and 2 functions that work together to consolidate multiple worksheets from the same workbook onto one new sheet by appending the data to the next empty column that works just fine.
Sub ConShtsClmn()
On Error GoTo IfError
Dim Sht As Worksheet, DstSht As Worksheet...