I am in the NC National Guard, and I am working on some spreadsheets to make
filing easier. I have one worksheet called "Alpha Roster" that I have listed
all the Soldiers within my Unit. This worksheet list the Soldiers each on a
separate row, and I have various data listed in the columns--last name, first
name, MI, SSN, Location, ect.

I would like to be able to pull all the data in a row off this worksheet
into another if certain criteria is met within one column.

For example, I have three locations--Kinston, Wallace, and Beulaville. I
would like to have all the rows having Kinston in column "M" pulled to the
second spreadsheet I'll call DET1. The same applies for the other locations
on different spreadsheets called DET2 and Echo.

Please help. How do I get these rows of information to be displayed on the
second and third worksheets? This will allow me to have updates made only on
one sheet, but view data on various sheets based on what I need to accomplish.

Thank you all for your time and assistance.