Trying to drag down multiple formulas that use other cells, but the results are not as desired.

[daft21]

I apologize if my terminology and explanations are not very coherent, but I will do my best to explain what I am trying to do.
This is for my work, and I would appreciate it someone could help me find a solution to this.
I am given a table of dates for different milestones of a set of projects, and for some reason my Project Manager wishes to have those same dates conglomerated into a format in the following fashion:

Project Number	Process	StartDate	EndDate
Project 1	AW	Jan-23	Jan-23
	SC	Feb-23	Feb-23
	TR	Mar-28	Jun-30
	DE	Jul-30	Jul-30
	DP	Jul-30	Jul-31
	PS	Jul-31	Aug-31
Project 2	AW	Jan-24	Jan-24
	SC	Feb-24	Feb-24
	TR	Mar-29	Jun-31
	DE	Jul-31	Jul-31
	DP	Jul-31	Jul-32
	PS	Jul-32	Aug-32

(The abbreviated words on the left are the labels of each milestone, they are not important to know what they stand for)
The dates are currently being extracted from the table mention before with formulas as simple as =P2, =R2, etc. (All from the same sheet, and the table is to the right of the table that my project manager is requesting out of me)
The table looks like the following:

	AW	SC	TRS	TRE	DE	PSS	PSE
Project 1	Jan-23	Feb-23	Mar-28	Jun-30	Jul-30	Jul-31	Aug-31
Project 2	Jan-24	Feb-24	Mar-29	Jun-31	Jul-31	Jul-32	Aug-32
Project 3	Jan-25	Feb-25	Mar-30	Jun-32	Jul-32	Jul-33	Aug-33

(Note: These dates were modified for the purpose of demonstrating what I am working with, but altered to keep the information related ambiguous)

So my issue is the following: As I highlight the columns under "Start Date" and "End Date", down to the row "PS", I try to drag down that entire selection so that excel will auto generate the formulas, extracting from the next row (the next project's row) data. In other words, since I am extracting data from "Project 1", which we'll say is 'row 2' on excel, I would want the the auto-generation of formulas to follow row by row, from Project 2, 3, and so on.
What occurs is, as I drag down that selection, it seems to 'skip' rows and give me non-consecutive results. So instead of every formula going in order from row 2, 3, 4, etc., it goes to row 2, 7, 13, 21, etc., skipping the dates I need to extract from on the table provided.
I really would appreciate it someone could help me out with this.

 

[nemmi69]

You need to show the formula

 

[daft21]

You need to show the formula

The only formulas I've been using are "=P2", "=Q2", "=R2", etc.
I've provided a screenshot to show the format of what I'm working with, and highlighted in light red the error that I'm receiving.
Again, the only formulas I'm using are as mentioned above, and they are implemented on columns 'C' and 'D'.

 

[daft21]

And just to clarify, what I'm trying to do is waste less time by just highlighting the cells in columns 'C' and 'D', and dragging them down to 'hopefully' automatically extract the data from the table in columns 'P' to 'V', without skipping each 'Project #'. But for some reason when I drag the highlighted section down, it extracted from the table row from 'Project 8' instead of 'Project 3' as I expected.