Macro to open File and copy data from all sheets

[howard]

I would be appreciated if someone can please help me with code to do the following

I need to open up a workbook and copy the data on all sheets (A1:BA up to the last row containing data in col B) to sheet1 on the destination workbook. The data on each sheet must be copied directly below the last data from the previous sheet copied

For eg if sheet1 is A1:BA100 and Sheet2 is A1:BA50, then A1:BA100 from the source sheet1 must be pasted on sheet1 A1 , A1:BA50 on sheet2 must be copied into A101 on the destination sheet1 etc


I would greatly appreciate your assistance