Data Import and Filter
 

I am trying create a summary of 3 seperate spreadsheets.
I need to pull rows of data meeting a cerain criteria.

Right now I have a query set that is pulling all the data over from one
spreadsheet. Then I deleted the columns I didn't need. Then I sorted the
list. Then filter the list.

Is there anyway I can have excel do this automatically?
I need excel to the following:

In Row 1 enter: "Book 1"
From "Worksheet1":
Pull data from columns A (place in column A of new worksheet),
E (place in column B of new wkst),
K (placed in column C of new wkst),
M (place in column D of new wkst)
that have "Renew", "No Contract", or "Expired" in column M.

Skip a line and enter: "Book2"
From "Worksheet2":
Pull data from same columns as above, except from "Worksheet2"

Skip a line and Enter: "Book3"
Same as above using "Worksheet3":