Named field problem - Microsoft Community

i having trouble named ranges.i 

my workbook contains 9 sheets.the 9 divided up, month, 3 sheets month. have named ranges/cells defined global each sheet,1-4-7, 2-5-8 , sheets 3-6-9.

sheet 1 detail transaction sheet, sheet 2 budget actual summary , other sub-totaled transaction list.

each matching sheet identical others. have defined named ranges/cells global named ranges when switch sheets data being used other sheets.

i have read , re-read find names , thought doing correctly.

any pointers appreciated.

theoldputerman

john

please let know problematic range comes in refers to: box? need formula problem occurs.

Office / Excel / Windows 10 / Office 2016