Cannot select content of some cells from one worksheet to another with = formula

I have a accounting workbook for our household expenses with a worksheet for each month.  In the NEXT month, I use the = formula to select a cell from the previous month; i.e. In the opening debits c...