Can I have a Macro that will automatically filter a spread sheet, pick a
specific value from a different sheet in the work book and copy the results
to a different sheet in the workbook?

For example:

Sheet 1 has the list of material numbers that are being ran.
Sheet 2 has the list of orders for that day with specific material numbers.
Sheets 3 - 9 is where the data will be coppied to for each individual line.
A separate sheet has been made for each line.

I will need to use the data from sheet two 7 different times to gather all
the data for each line/material.