Combine Multiple Sheets into One and Update Continuously

[purpleeagle]

Hello,
I am brand new to this forum and am having some trouble finding a Macro that fits my needs. My problem is this: I have a workbook with 6 sheets that I update daily: 1-10, 2-8, 1-67, 3-16, 2STB, 204th. They all contain a header row and the last row in each sheet is used to calculate subtotals. What I need is a macro that will copy and paste all the rows containing data (not the header and not the subtotal) into one "Master" sheet. Ideally, each time I add row to one of the 6 sheets, I would like it automatically be added to the master sheet. There are other sheets in my workbook that I do not want to be included in this function as they simply serve as references for my VLOOKUP functions in my 6 working sheets. I have experimented with lots of Copy/Paste rows code that I've found on the forum but as I am brand new to VBA have not been able to manipulate it to fit my needs. Also, is there anyway I can upload my spreadsheet so that the people working my questions can actually work with my sheet? I see the HTML maker download is not up right now for some reason when I look for it on the site. I am working with the 2010 version of Excel. Please let me know if the example provided is not sufficient or not in the proper decorum per forum etiquette. Thanks for the help and I will post my second issue in a new thread.

Control #

Losing BN

Gaining UIC

Gaining BN

Gaining BDE

Lin

Nomenclature

Qty

QTY Executed

DST Suspense

Days Remaining DST

Suspense

Days Remaining

Remarks

Status in DST

FSC

Above/Below Line

IUID

D.13.340.1978

1-10 CAV

WANLAA

HQ, 1ABCT

1ABCT

70156N

PAPER SHREDDING MACHINE, ELECTRIC MTR DR

1

February 28, 2014

26

6-Jan-14

-27

RECLAMA; Unservicable

Open

Below

D.13.352.2991813

1-10 CAV

WE5JAA

HHD, 759TH MP BN

759 MP

T41203

TRK CGO W/MHE M1084A1

1

January 24, 2014

-9

24-Jan-14

-9

DOL

Open

1-10 FSC

Above

D.13.345.788

1-10 CAV

WHZZAA

1-25 ATK

4th CAB

T87243

TRK TK FS M978

1

January 1, 2014

-32

31-Jan-14

-2

DOL; Ready for PU; GUIC needs to extend if cannot meet suspense

Open

1-10 FSC

Above

D.13.307.7

1-10 CAV

WJKGAA

STB

1ABCT

A79381

ANT GRP OE-254()/GRC

4

December 31, 2013

-33

15-Feb-14

13

Moved to 2/15 by Chief Sutton

Open

Above

7

0

<colgroup><col width="121" style="width: 91pt; mso-width-source: userset; mso-width-alt: 4425;" span="2"> <col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <col width="141" style="width: 106pt; mso-width-source: userset; mso-width-alt: 5156;"> <col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <col width="66" style="width: 50pt; mso-width-source: userset; mso-width-alt: 2413;"> <col width="394" style="width: 296pt; mso-width-source: userset; mso-width-alt: 14409;"> <col width="31" style="width: 23pt; mso-width-source: userset; mso-width-alt: 1133;"> <col width="81" style="width: 61pt; mso-width-source: userset; mso-width-alt: 2962;"> <col width="123" style="width: 92pt; mso-width-source: userset; mso-width-alt: 4498;"> <col width="95" style="width: 71pt; mso-width-source: userset; mso-width-alt: 3474;" span="3"> <col width="222" style="width: 167pt; mso-width-source: userset; mso-width-alt: 8118;"> <col width="64" style="width: 48pt;" span="2"> <col width="100" style="width: 75pt; mso-width-source: userset; mso-width-alt: 3657;"> <col width="64" style="width: 48pt;"> <tbody> </tbody>