Auto populate 35 WBS Cost Reports

Hi All,

I have a cost report 'WBS' sheet with multiple columns, including budgets, actual period cost, cumulative cost, VOWD, remaining etc as attached

This cost report sheet is one of 35 separate sheets which are unique only by WBS

I am attempting to find a way to auto populate each of these input columns as much as possible to reduce the time for manual entry

I need to keep historical period data for subsequent analysis and to be able to go back and run the report for a previous period (if moved on eg 2 or 3 months)

I was hoping to find a way to use an input sheet, VLookup, referencing the date driver cell in B2

The budget section I have linked to source documents

Any suggestions greatly appreciated

C

The raw data does not exist as yet. When it will be available it will be in tabular format with ref to the 'cost description' from the test formula spreadsheet. It will be cumulative actual cost only

Yes I do understand rather ambiguous, thanks for the advise anyway. I shall go play around with INDEX-MATCH etc until I have data format firmed up

Thanks again