You could store all the information on the Supplies sheet, with a column
to indicate the teacher name.
Then, you could filter the data (DataFilterAutoFilter) for a specific
teacher name, and print out their data when requested.
Keeping it on one sheet will be easier to maintain, and you can use
filters to view specific data, and pivot tables to summarize.

There are instructions for filters and pivot tables in Excel's Help, and
he

http://www.contextures.com/xlautofilter01.html
http://www.contextures.com/xlPivot01.html

DebbieS wrote:
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!


--
Debra Dalgleish
Contextures
http://www.contextures.com/tiptech.html