Insert number of rows with data to new sheets based on values in cells

I'm running into a problem with a workbook that I'm working on in Excel 2010. There are 3 worksheets, "Overview", "Data Entry I", and "Data Entry II". I need certain numbers of rows to be inserted with data based on the number values found in columns C and D. These will need to be inserted across between the 3 worksheets. These inserted rows with data must be added in the next available empty row (after the names).

Here is the layout for the "Overview" Sheet:

A	B	C	D
1	POSITIONS	OPEN	PROJECTED/ADD
2	DATA ENTRY I	3	2
3	DATA ENTRY II	0	4

I need "Data Entry I" Sheet to look like this:

B	C
1	John Smith
2	Jane Doe
3	OPEN
4	OPEN
5	OPEN
6	PROJECTED/ADD
7	PROJECTED/ADD

And I need "Data Entry II" Sheet to look like this:

B	C
1	John Doe
2	PROJECTED/ADD
3	PROJECTED/ADD
4	PROJECTED/ADD
5	PROJECTED/ADD

I was only able to find some information on inserting rows based on cell values that are on the same sheet, but I wasn't able to find anything where multiple sheets are involved. Please help!

Thanks yudlugar and JOHN H. DAVIS for your quick response and help. I'm at work right now and I had to add a few new rows into each of the sheets and I'm afraid these new additional rows will require changes to the VBA in order for it to work properly but I am not sure where to make the appropriate changes. I've uploaded a sample file to show this. Can you please take a look and see which lines in the VBA code will need to be changed? Thank you so much in advance!