VBA - Copy multiple sheets to one single sheet based on the sheet's content : I have an excel workbook which contains more than 50 sheets. I need to copy every sheet that contains "Seasoned Passthrough OAS" and paste it to the sheet whose name is "BC-Summary". How can I achieve this by VBA? Urgent!! Thanks.