Lonnie,
Attached does what you want. Enter a new name in first free row on Personal Entry sheet and run the LOADING macro.
I have also changed your "Sum" formulae in the YTD sheet.
You do not need to call each sheet individually. This formula will add the value of cell B2 in every worksheet from the first one you identify to the last one:
=SUM(January:December!B2)
NOTE: If you add or move any sheet(s) so they are before or after the two sheets you named, any values in them will not be included in the Total.
Bookmarks