I need to count non-blank cells in a series of sheets and put that info on a summary page. The problem I'm having was trying to use counta - it works fine when the sheets exist but I'm generating the sheets dynamically and I get a #ref! when I go back to the summary sheet after the sheets have been created. It's 1:05AM and I'm not sure if that makes sense so I'll give you the particulars of the workbook.

Sheets that exist in the "template" that pertain to this question:
Summary
GL-045-BW (B6)
GL-040-BW (B5)
GL-SLD-BW (B12)
SP-X40-BW (B7)
SP-X45-BW (B8)
XD-SLD-BW (B9)
SW-M40-BW (B10)
SW-M45-BW (B11)
AR15RC-BW (B33)
ARHNDL-BW (B32)

I need to count the non-blank cells in all of the *-BW sheets and put the values in the Summary sheet in specific cells as noted after the sheet name. I have looked through everything I could find but I'm not seeing anything that makes sense to me...

Any help would be appreciated!

Gary