VBA code to report from worksheets to a cover sheet

[robbo1172]

Hi all

I have attached a spreadsheet that I am developing to help me forecast finish dates based on resources (men) I have available and use.

The resources are assigned in the right hand table with a drop-down list.

The grey cells are entered manually and the green ones update automatically (this all works as intended), but as per my two sample worksheets, I would like the job number (cell B4) to report to the front worksheet, along with the resources allocated (cells B9 to B16) to the appropriate week. I would like this to occur with any worksheets I have created in workbook.

On the worksheet 232325, there are 2 resources booked (cell B9) for 2 weeks (cell E9), so the front sheet will insert 2 in each of the days for the first two weeks (week starting 4/7/16), then 3 men for one week (week starting 18/7/16) etc.

I expect that at any time there may be between 10 and 20 worksheets at any time.

Hopefully my sample explains it well enough, if not please let me know and I will try and explain further.

Any help greatly appreciated.

Thanks, Robbo