This one was a lot more convoluted than I thought it would be, unless I've completely missed something obvious!
In the attached there are 3 solutions.
1. Formula in column C of the Dashboard sheet. This depends on the formula in cell I2 of the Returns April - June sheet.
2. Formula in column R of the Dashboard sheet which is a version of (1) but incorprates the I2 formula. This eliminates the need for the I2 formula. I'd call this a mega-formula but it could be made into a named lambda formula which would make things easier for the user.
3. A Power Query solution in cell G1 of the Dashboard sheet. I prefer this solution to the others. After you've updated the data in the table on sheet April Orders and/or the one in the Returns April - June sheet, you just need to right-click on the green table in the Dashboard sheet and choose Refresh.

Attached Files

msofficeforums51177Ret_ENG.xlsx (26.4 KB, 3 views)