Can table data move with column headings?

[ali_jellybean]

Hello,

I have a table showing project income by month for various project that the company is running for the next six months - a dummy example of layout/data is in the image below. What I want to be able to do is update the date of the first column and have the subsequent column headings update and the table contents to update to move along with their column header.

I have figured out how to do some parts of this but can't find a way to get the elements to fit together in a table. Is it possible to set this up within a table or would I need the table to be pulling the data from a separate source?

 

[Jeffrey Mahoney]

Here is how to have the dates dynamic. Now I'm assuming you need some formulas to sum the values based on those dates, or do you have those already?

Book2
	A	B	C	D	E	F	G	H	I	J
2		May-24	Jun-24	Jul-24	Aug-24	Sep-24	Oct-24	Nov-24	Dec-24	Jan-25
3	Project 1
4	Project 2
5	Project 3
6	Project 4
Sheet1

Cell Formulas
Range	Formula
C2:J2	C2	=EDATE(B2,1)