My budget workbook is broken up into 16 worksheets, the "Supplies" worksheet
being one of them. The "Supplies" budget is broken up into 24 parts (so I've
set up one teacher/department budget per worksheet). I want to enter
information only once (on one of the individual worksheets), but would like
it to copy over to the main "Supplies" worksheet. Do I do it by running a
macro, using a function, or copy/paste?

I did the Edit, Fill, Across Worksheets thing, which put the 8 rows of data
from the first individual worksheet onto the first 8 rows of the main
"Supplies" worksheet. Then when I did the next one (which had only two rows
of data), it transferred them onto the first two rows of the main "Supplies"
worksheet, replacing what was there from the first worksheet.

Is there a way it would put them on lines 9 & 10 instead? That way, I can
have my whole "Supplies" budget in one place for the principal, but if a
teacher asks for a copy of their individual budget, I can provide that too
them (without them seeing what everyone else has in theirs). I hope this
makes sense to someone out there. This would be such a great thing to know
and save time too!
--
DebbieS