VBA COde For copy and paste B column of every sheets to new workbook in one sheet

Hi All,


I have 150 sheets in one workbook, named like Sheet1, sheet2....sheet150, i want copy bB column from all sheet and paste in New Workbook in sheet one.


Thanks,
Chetan