I am trying to find an easy way to take a full spreadsheet and using
different sheets write a formula to take certain inflormation into a new
sheet a re sort it into different orders.

eg. I have colums of data in this case the colums are bassed on electrical
calculatios, weights. and other relevent information. Then each row is a
seperate piece of equipment that has had the information entered.

I now want to create a new sheet, in this I want to take the Information
from colomn Q then H , N and O from the first sheet I want to re sort this
information In lowest to highest from column Q with extra formula eg totals
added on the end. I need it to be able to carry the details from the original
sheet so If I were to change the No. in row Q in the first sheet then it will
automatically move all the data in that row in this new sheet.

Can anyone please give me some guidline of how to acheive this. What sort of
formula do I need to write to keep this all to tally.

I would really appreciate any help

Cheers

Andy