No, the data cannot be moved to 1 sheet. That'd be great though and I see how that'd be easier. Each sheet covers actions like buy products, fixing them, information from our vendors then formulas based on the different quantities that are being shipped to us or broken. So each sheet is a completely different report.

Thanks for the advice.

snb, that code looks good, I'm going to test it soon! Thanks!