Lookup data from one sheet and add that data dependent on the month put into "X" cell.

Hi,

I have created a cashflow, I am now looking to create monthly Variance report on a separate sheet. The actuals are on QuickBooks Online, annoyingly I can not extract the data directly so I will add this in manually.

However, I would like to be able to add the data from the main sheet into the variance report without having to keep adding manually.

The variance report will need to show the description column and the data of the month based on the month put in "X" cell in the variance report. I would also like the desciptive column to show exactly as it shows on the main cashflow so that if new lines are added on the main cashflow sheet, these are then automatically added on the variance sheet.

Hopefully this makes sense.

Many thanks.

James.