Pulling info and links specifics

[Kayla]

I have a complex question and need a quick answer. I am working on a
workbook that has auto parts and their makers and vendors listed. What I
need to do is take and have the computer pull out certain info like the
vendor and what parts they sent, the price and the like and place it in a
different spreadsheet. I know how to link but I can't figure out how to make
it work when the data will be constintaly changing and may not always be in
the same places with in the main spreadsheet. It will have to be able to
sort the info out onto about 30 different worksheets for easier reference.
Any Ideas?

 

[Debra Dalgleish]

You can use an Advanced Filter to extract data to a different worksheet.
There are instructions here:

http://www.contextures.com/xladvfilter01.html

And there are sample files here:

http://www.contextures.com/excelfiles.html

Under the heading 'Filter', look for 'Update Sheets from Master'