Copy discontinuous range

Can you attach a small sample workbook? I find it hard to visualise things like this. You might be able to use CurrentRegion or Areas.

Thank you for your help. Attached is a sample workbook. My real master list has several hundred such groups of rows. If I select any row within a group of rows, I would like to copy all the shaded columns (those that do not have formulas) within the group of rows and paste them to the end of another sheet. I'm getting hung up on finding the top and bottom of my groups of rows. Your help is appreciated.

To remove all doubt, please can you add to your file an illustration of your expected results?

Thank you for your help. On the sample worksheet you can see three groups of rows, each separated by a merged cell with bold outline. The first two groups are populated with sample data, the third is not. This represents my master list, which will contain several hundred such groups, each with it's own sub-total line (labled "Direct Construction Cost"), a blank row, and a merged/bold row. The columns shaded grey here only contain data, the rest contain formulas.
The individual sheets will already be populated with formulas that have various links. I don't want to mess those formulas up. That is why I only want to copy/paste the data columns that are shown on the sample as grey.
When I select a cell in a group of rows, I want to select only the data columns from the merged/bold row above the selected cell down to and including the merged/bold row below the selected cell. I want to copy those 4 ranges and paste at the bottom of my individual sheet.
I have two problems. The first is selecting the rows between merged/bold rows. The second is overcoming the limitation on copy/paste of discontinuous ranges.
I hope that makes it more clear. Thanks again for your help.