Select Dynamic Ranges from multiple worksheets and copy to another wkbk with same wksheets

Hey Guys,

I am working on a project and am stuck currently. I have attached a sample workbook with code that I have written to do the half of what I need to do. What I am trying to accomplish is I will get get a workbook like the one I attached with multiple store data. I need to sort through all the data and make a new workbook for each store in the report. I have figured out how to sort through the Store Sheet and filter out all the stores and add them to another workbook. What I am having difficulty with is how to add the data from the Chain Sheet to the new sheet created. For example, after the code runs for the first store, it will create a new workbook and on sheet1 it will have all the data for the JCPenny stores from the Individual sheet. Then on sheet2 I need to get copy the row that says JCPenny from Chain sheet from the original Sheet then save it. Let me know if what I have said does not make sense and I will further explain.

Thank you in advance!