copy dynamic range from multiple workbooks/sheets

I have several worrkbooks, all in the same directory, that each have a sheet named "forecast". I would like to have a macro in a separate workbook called "rollup" that will copy a range of data from each of the "forecast" worksheets and consolidate that data into a new worksheet that would be labeled with the date. Basically I would create this "rollup forecast" on a weekly basis.

The data I am interested in always starts in row 6 and is in columns A through P but varies in length.
Additionally I only want to copy the data if column B contains text.
Thanks,