Hi....in sheet 1, I have a column that has unique numbers and using the
following formula to lookup the field in sheet 46500! Column H and then count
the unique frequencies in sheet 46500! column A.

=SUM(1*(FREQUENCY(IF(('46500'!$H$2:$H$43207<"")*( '46500'!$H$2:$H$43207=$A4),'46500'!$A$2:$A$43207), '46500'!$A$2:$A$43207)0))

How do I change that formula so that it also reads additional sheets (46501,
47400, 43100, 43103, 47300) and only counts the unique combination like the
formula above does for one sheet? Please Help