Formula to move data depending on project start date

Hi,

I am sure there is a simple solution, but of course I cannot think of it. Basically I have a list of projects ("base info") with costs over the duration of the project spread over several months. I want to have a sheet which overrides the info by changing start date will lay out all the info based on that. E.g. if a project starts in April in "base info", I want to be able to choose a month, say May in the drop down and all the same project cost information starts from May onwards. In the sheet "calculation needed" I have moved all projects to April manually. Ideally a formula that would change each project automatically depending on the month in column A would be great.

Thanks

Thanks for the response Glenn. I was hoping to avoid VBA. I want to copy the data but change the start position (in a different sheet not the same sheet). So if project starts in April in the main sheet I want to be able to change the start month in the other sheet to May (if any of this makes sense)

Haha thanks Glenn. I appreciate any help you can give.

Thanks that is amazing. I don't know how you come up with answers everytime so quickly. I am not sure about the formatting issue must be a settings issue. Have a good flight