Merge Multiple Sheets from Multiple Work Books into 1 sheet - but with specific Data Ranges.

[MosesAleksandr]

Hello Everyone,

I have greatly benefitted from these forums already, but now find myself stuck so I joined officially. I am hoping you can all once again help me find a solution to my problem.

I want to import data from specific workbooks (Example: Apples wkb; Bananas wkb, Pears wkb, etc.). Each workbook has several tabs with specific Batch Data (Ex: Apples WKB: Sheet Names: Green Apples, Red Apples, Yellow Apples, etc.). I want to import specific cell ranges w12:AR(Last) as the final row count is variable, but the column lengths are consistent.

I want this data to be pasted into a different workbook with a fixed name (Ex: All Fruit Data), and paste into a sheet with a Fixed Sheet Name (Fruits from East Coast) with paste starting in cell D2, but adding continuously to the bottom last populated row/column, as the new data is pulled over.

My final goal is to have one excel file I can run this macro on as new data is added to the other sheets, so I can continuously monitor the full picture of inputs.

 

[alansidman]

See if this video is helpful.

 

[MosesAleksandr]

See if this video is helpful.

This worked perfectly! Thank you so much. You are a life saver. I totally just avoided hours and hours of manual data transfer.