Can something like this be done?
I have a list of 600+ random 5 digits numbers each of which coorisponds to a specific page in a secondary work book.

My question is that if say i want to count how many enteries each seperate page has is there a way to insert my cell value into the file path for the function.

for instance if i have a colum that reads 23, 89, 45,64 ect...
and i want to perform a count function on the pages that corralate to those #'s
=COUNT('[OnTrac.xls]X'!C:C)
where "X" would be 23 or 89 ..... Of course i could just link everyone seperatly but that would get tedious really fast.
Thanks for the help