Expert needed... Validation On Multiple Sheets

I have a workbook set up that has a budget sheet with 19 different Sections. Each section has 20 rows that have drop down menus via data validation. Each section's data validation references its own sheet so there are total of 29 sheet and only 19 are used for the drop down menus to reference data. I have been using an offset formula to be able to add to my lists =OFFSET(DIV1!$D$2,0,0,COUNTA(DIV!!$D:$D),1) from the Budget sheet. I can get the list to add on Sheet Division 1 but not Sheet Division 2,3,4,ect... If anyone could help I would be greatful!

'works with =OFFSET(DIV1!$D$2,0,0,COUNTA(DIV!!$D:$D),1)

'Division 1

Please Login or Register  to view this content.

'Wont WORK

'Division 2

Please Login or Register  to view this content.

Welcome to the Forum, unfortunately:

This is a duplicate post and as such does not comply with Rule 5 of our forum rules. This thread will now be closed, you may continue in your other thread.

You shouldnt post the same question in the paid and free forums.

Thread Closed.