I have placed almost all the entries from the "Your Monthly Proforma" sheet to the "Your ProForma (with Annual)" but there are still invalid references. Upon close inspection I noticed that the formula's for all those with invalid references were removed by Excel, as it is how Excel works. I would need an old version of your workbook from the same or any other franchise so that I can get the formulas as well as the interlinked data of formulas to complete the same.