Get data validation list from other sheet of desired choice

[neerajarora8077]

hello everybody,
I want to get a data validation list in dress form sheet in cell J1 after choosing a fixed condition in cell H1. I have created a formoula in sheet2 but it dosent work as I paste it in data validation options list of refer to box. pls help me to get the right formula which I can get to right list. for ur convenience I have also created the named ranges. I am a primary teacher and wants to make an excel sheet that every school can use it as most of school teachers dose'nt know enough about excel formulas. I have attached the sample file named "ALL STUDENTS LIST DESU 2015-16'.
THANKS IN ADVANCE
formula for data validationlist refer to box
=IF(H1=OR("1ST","1ST A"),'STUDENTS DATA'!$B$4:$S$103,
IF(H1="1ST B",'STUDENTS DATA'!$B$104:$S$203,
IF(H1="1ST C",'STUDENTS DATA'!$B$204:$S$303,
IF(H1="1ST D",'STUDENTS DATA'!$B$304:$S$403,
IF(H1="1ST E",'STUDENTS DATA'!$B$404:$S$503,
IF(H1=OR("2ND","2ND A"),'STUDENTS DATA'!$B$504:$S$603,
IF(H1="2ND B",'STUDENTS DATA'!$B$604:$S$703,
IF(H1="2ND C",'STUDENTS DATA'!$B$704:$S$803,
IF(H1="2ND D",'STUDENTS DATA'!$B$804:$S$903,
IF(H1=OR("3RD","3RD A"),'STUDENTS DATA'!$B$904:$S$1003,
IF(H1="3RD B",'STUDENTS DATA'!$B$1004:$S$1103,
IF(H1="3RD C",'STUDENTS DATA'!$B$1104:$S$1203,
IF(H1="3RD D",'STUDENTS DATA'!$B$1204:$S$1303,
IF(H1=OR("4TH","4TH A"),'STUDENTS DATA'!$B$1304:$S$1403,
IF(H1="4TH B",'STUDENTS DATA'!$B$1404:$S$1503,
IF(H1="4TH C",'STUDENTS DATA'!$B$1504:$S$1603,
IF(H1="4TH D",'STUDENTS DATA'!$B$1604:$S$1703,
IF(H1=OR("5TH","5TH A"),'STUDENTS DATA'!$B$1704:$S$1803,
IF(H1="5TH B",'STUDENTS DATA'!$B$1804:$S$1903,
IF(H1="5TH C",'STUDENTS DATA'!$B$1904:$S$2003,
IF(H1="5TH D",'STUDENTS DATA'!$B$2004:$S$2103,)))))))))))))))))))))