I have multiple workbooks and i need to create a summary sheet that can pull
information from all the other workbooks. the cells that i need to pull are
the same on each of those and i know there is a pull formula that would make
this easy for me but i'm not sure how it works. otherwise i'd have to go in
and manually input each of the cells that i need into the summary and that is
very time consuming.

Please help if you can.

The easiest way is to open both files; in the target file cell type =, now
point at the cell in the source file cell. This gives a formula in the form
='[Travel Apr 07.XLS]April'!$B$4 where the file name is within [ ] , and
April happens to be the name of the sheet in the source file.
If you need to copy this formula down a column you will need to remove the $
signs that make it absolute
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"tnguyen030" <(E-Mail Removed)> wrote in message
news:08EEE30C-F610-49A8-A95E-(E-Mail Removed)...
>I have multiple workbooks and i need to create a summary sheet that can
>pull
> information from all the other workbooks. the cells that i need to pull
> are
> the same on each of those and i know there is a pull formula that would
> make
> this easy for me but i'm not sure how it works. otherwise i'd have to go
> in
> and manually input each of the cells that i need into the summary and that
> is
> very time consuming.
>
> Please help if you can.