I have a master list of equipment that can be installed on a piece of equipment on sheet1 of my worksheet:

Equipment list Machine1 Machine2 Machine3

Piece of Equipment1 Location Weight X X
Piece of Equipment2 Location Weight X
Piece of Equipment3 Location Weight X
Piece of Equipment4 Location Weight X

I have made drop-down boxes to indicate what equipment is installed on each machine. I have made sheets for each machine and would like to make a list of the installed equipment with the the weight and location (different cells) on the sheet for the individual machines to generate off the master by dropping down to the X. I would also like the equipment to be removed by removing the X. So far I have been able to have the cells copy over to the other sheet, but they always go to the same cells. I would like it to make a nice condensed list, with no empty rows in between. Thanks for your help.