Need Formula to Automatically Align and Transfer Data from "Data" Sheet to "Input-Report"

[Divijgarg]

Hello,

I have an Excel file where I download budget data from Volac software into the "Data" sheet. The issue is that the downloaded data starts from the month when the project begins, but I need to align it so that the months always start from a fixed column (e.g., January or Column B).

Additionally, I want this data to be automatically transferred to another sheet, "Input-Report", without manually copying and pasting. The dataset can have up to 900 rows.
The issue is that when I download data, the months start from different columns, depending on when the project began. I want the data to be shifted left so that the first nonzero value always appears in the first month column.

What I Need Help With:
1.) A formula (SUMIFS, VLOOKUP, SUMPRODUCT, or any other method) to shift data left so that months always start from Column B.
2.) A formula to automatically pull data from "Data" into "Input-Report" for easy reference.
3.) If formulas can't do this, a VBA solution that runs whenever new data is added.

Any help would be greatly appreciated! Thanks in advance.

Excel Problem.xlsx

[avk]

I have Data sheet modify as per Data_modify sheet
Input-Report sheet "B2"

=SUMPRODUCT((DATA_MODIFY!$A$2:$A$15=$A2)*(DATA_MODIFY!$B$1:$N$1=B$1)*(DATA_MODIFY!$B$2:$N$15))

copy paste across.
File attached