I have a workbook that will always have a different number of worksheets. Each sheet will have a different part number (always in the same cell O100) and a different quantity (always in the same cell E21). I want to create a macro that will create a new sheet and make a column that will compile the part numbers and quantities from each sheet. I honestly, don't even know where to start. i know this is possible. Any help you can give would be appreciated.

Thanks,
Jeremy