Automating Dynamic Range or Table copies to Single page

[pacman_d]

Hello all,

I have been working on putting together this new quoting tool for the group and I have a good deal done with Minimal coding required. However, I have ONE thing that i have been stuck on for a few days.

In the attached workbook, you will see that there are a number of tabs. I Specifically need to pull Data from the (Professional Services),(Materials), (Maintenance), and (Add-Alt) tabs, and Copying validated data to the (EstSummary).

1. Source data begins at B13 (Typically the service description.)
2. A function to loop down the column to the end and create a dynamic array
3. A copy of that data and a lookup on the (EstSummary) destination start target cell (C21 and H21) to identify if that sheet is clear. If not, ask if I want to clear it...

1. If (EstSummary) is clear, then paste the range data into the column
2. Same for the other tabs appending to the bottom of the first tab's data and so on
3. I Would LOOVE it if the data that gets pasted could be dynamic as well. Forgive me for not being more clear but i am very new to VBA and am reading a ton. But im tired and i need help...

1. I will use conditional formatting to get the estimate page.

I have attached the file for your reference.

Thanks so much for taking a look.. It is a bit messy while still in draft.

Best,

Paco