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.