Here is my spreadsheet: https://docs.google.com/spreadsheet/ccc?key=0AgmD6-Z4d2aVdE9pR095OTJrVE1wS3FIZzZpVFRJMmc#gid=4
What I want to happen is I enter data in the sheets marked Head, Neck, Shoulders etc.
I want that data to then be put in specific areas of LFR and Normal based off of what is in the location field of Head, Neck, Shoulders etc sheets.
For example, Under the Helm tab there is: Item Level Item Name DPS Increase Item Location 483 Firebird's Helmet +2171.93 Sha of Fear - Terrace of Endless Spring (LFR) 483 Crown of the Doomed Empress +211.27 Grand Empress Shek'zeer - Heart of Fear (LFR)
I want the LFR Raids sheet to list Firebird's Helmet under the Terrace of Endless Spring section automagically and then it would put Crown of the Doomed Empress in the Heart of Fear section of the LFR but it would also grab anything that I have input from Terrace of Endless Spring from the other sheets (neck, legs, gloves, etc) in there as well.
My formatting is different a little from the 2 sheets but I will change that if this is request is able to be performed.