Hi nightcrawler-jay;

You didn't include a sheet that showed an example of how you wanted the results to look.

Here's how I would handle it based on what you have said so far: I would write a macro that created a sheet named "9080007" and copy all the data for 9080007 from Sheet1 onto that sheet.

If that's all you want, an easier way is just use "autofilter".
In the menus: DATA>FILTER>AUTOFILTER. That will make every column heading like a listbox. You just go to "Material Number" heading and select the material number you want, and it is automatically filtered. Then you can print the sheet as is. When you're done printing, you can turn off autofilter the same way DATA>FILTER>AUTOFILTER

If you want the macro to figure out what batches to include in a report, you will have to tell us how to figure it out. Describe it like you would describe it to a new employee that doesn't know anything at all about your business. Remember I'm a new employee, and I have no idea what SLOB or SAP or Material Group are, so explain it to me that way, and I can write a macro to do it for you.