I am having trouble consolidating data from multiple workbooks into one master version

[jamesplant77]

Hi, I am new to VBA so struggling to get this to work. I have a number of workbooks in one directory that are exactly the same apart from the name of the workbook. I want to take all the active rows and columns and copy the data into one master version, so that workbook b data is pasted below workbook a with no gaps. All workbooks are entitled Demand Management - A, Demand Management - B etc and the data that I need to transfer is on the first tab called FORECAST. All data is from row 6 onwards, upto column BO. I have a master version of the workbook set up that mirrors the other workbooks and just need the code to assign to a button to perform the consolidation. Any help would be greatly appreciated!!