Working across sheets

[fatboy95]

I am trying to build a spreadsheet that has multiple sheets.

NameList sheet is built like this
Column A
A1 = 1
A2 = 2
A3 = 3

Column B
B1 =IF(COUNTIF('J-3'!$A$2:$D$41,A1)>=1,"",ROW())
B2 =IF(COUNTIF('J-3'!$A$2:$D$41,A1)>=1,"",ROW())
B3 =IF(COUNTIF('J-3'!$A$2:$D$41,A1)>=1,"",ROW())

Column C
C1 =IF(ROW(A1:A15)-ROW(A1)+1>COUNT(B1:B15),"",INDEX(A:A,SMALL(B1:B15,ROW(INDIRECT("1:"&ROWS(A1:A15))))))
C2
=IF(ROW(A1:A15)-ROW(A1)+1>COUNT(B1:B15),"",INDEX(A:A,SMALL(B1:B15,ROW(INDIRECT("1:"&ROWS(A1:A15))))))
C3
=IF(ROW(A1:A15)-ROW(A1)+1>COUNT(B1:B15),"",INDEX(A:A,SMALL(B1:B15,ROW(INDIRECT("1:"&ROWS(A1:A15))))))

This is working great off of sheet J-3. I can't figure out how to make it work when I add more sheets like J-4 and so on.

Thanks for any help...

Thanks for any help

 

[baodinh]

Insufficient information to help. Do you have a sheet called NameList that does the reference to J-3, J-4 etc? Perhaps you should do all the calculations in the J-3, J-4 sheet and simply summarise in the NameList sheet. Post and example and I'm sure we can find a solution.