How can I create a master spreadsheet from different workbooks

Giganews Newsgroups
Subject: How can I create a master spreadsheet from different workbooks
Posted by:  Dawn Williams
Date: Wed, 3 May 2006

I have a spreadsheet containing 12 worksheets.  The worksheets have several
columns of information against a record which has a unique staff number.

e.g. Worksheet  (Month 1)

ID No  Amount  Amount  Amount

I would like to create a master spreadsheet which contains each unquie ID
number against each month's information.  E.g.

                        Month 1
Month 2
ID No    Amount1  Amount2  Amount3        Amount1  Amount2  Amount3

Is there anyway I can pull the information against each ID number onto one
sheet (as above).  I cannot copy and paste from one to another because I have
leavers and joiners so they don't always match up.

I would be gratefuly for any help.  Many thanks

Dawn

Replies