Hi,

Does anybody know if there is a way to determine how much data is one
individual sheets in a workbook?

Something along these lines?

Sub CountWS()
Dim W As Worksheet

For Each W In Workbooks
   W.Count
End Sub