Hello, I am looking to create a macro that will create a "Summary" tab within my workbook that will copy a defined range (A7:B56) from all other worksheets and paste them to a new summary tab. I would like it to copy the formatting as well as the value. Also, I'm hoping to include the original worksheet name where the data came from as a column in the summary as well. A brief example below of how the summary tab would look where my two tab names are Animals and Movies (except less rows than my actual data). Then finally, if possible, I would like to delete any rows that had "None" in column A originally. Thanks for any help!