Hi,
Hopefully this will start you off....
I changed the dropdown box to one in the actual cell using data validation and referring to a Stores List on a separate sheet (That sheet can be hidden if needed).
I added the month column headers above relevant columns for lookup purposes, you can either hide them with the font colour or change the cell references in the formulas as you copy it across the table, try to avoid the merged cells if you can.
Put this in B8 on the dashboard sheet, and then copy and paste it into the appropriate sections for 'Actual' ......
Then for Budget, the sheet and cell refs just need to be changed, like this...
Start this one in E8 and then copy it to the relevant sections for 'Budget'......
As long as each column you are pasting into has the column header for month in row 5, the copy pasting of these should work for the whole sheet, either that or modify the appropriate cell refs in the formula for each month.
I think this is what you mean kind of?
I re-attached your workbook with some of this in place.
Regards,
Bookmarks