Copy the same column from multiple sheets into one sheet

[timthewineguy]

Hello,

I have a work book that has 20 different sheets in it - all with the same data - except for one column which is the variable.
In this case

column f contains the name of the wine supplier for a wine.
column g contains the wine name for a wine
column h - the year (vintage)
i - the price
j - discount
k - case size
l - is the quantity that a customer has ordered

there is a seperate work sheet by each customer

what I want to be able to do is place columns f -k in a new work sheet, and then have a separate column for each customers order so that I can see them all in one place before placing shipping orders and can easily to a total by each product. Is that possible please?

thanks

Tim

 

[timthewineguy]

[TABLE="width: 1818"]
<colgroup><col><col><col span="2"><col><col span="7"></colgroup><tbody>[TR]
[TD]CUSTOMER:[/TD]
[TD="colspan: 2"]Bottle Shops Bottle Shops[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD]Full Name (First name)[/TD]
[TD]Full Name (Surname)[/TD]
[TD]Merchant ID[/TD]
[TD]Email[/TD]
[TD]Contact Number[/TD]
[TD]Supplier[/TD]
[TD]Wine[/TD]
[TD]Vintage[/TD]
[TD]price[/TD]
[TD]Discount[/TD]
[TD]Case/Min Order[/TD]
[TD]Quantity[/TD]
[/TR]
[TR]
[TD]Bottle[/TD]
[TD]Bottle Shops[/TD]
[TD][/TD]
[TD]daniel@thebottleshops.co.uk[/TD]
[TD]hhhhhhh[/TD]
[TD]Alceño[/TD]
[TD]Sierra de Enmedio Sauvignon Blanc[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]€ 1.74[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alceño[/TD]
[TD]Sierra de Enmedio Rosado[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]€ 1.74[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alceño[/TD]
[TD]Sierra de Enmedio Monastrell[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]€ 1.74[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alceño[/TD]
[TD]Sierra de Enmedio Garnacha[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]€ 1.74[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alceño[/TD]
[TD]Hilanda Organic Monastrell[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]€ 2.26[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alceño[/TD]
[TD]Hilanda Monastrell[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]€ 2.37[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Alceño[/TD]
[TD]Hilanda Termino de Arribe[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]€ 3.11[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Château Sorbey[/TD]
[TD]Château Sorbey **PROMO** (usually 5€!)[/TD]
[TD="align: right"]2012[/TD]
[TD="align: right"]€ 3.32[/TD]
[TD]Promo[/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Château Sorbey[/TD]
[TD]Château Sorbey (only 120 btls left!)[/TD]
[TD="align: right"]2010[/TD]
[TD="align: right"]€ 4.58[/TD]
[TD="align: right"]2%[/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Château Sorbey[/TD]
[TD]Château Sorbey Cv Expression[/TD]
[TD="align: right"]2014[/TD]
[TD="align: right"]€ 4.26[/TD]
[TD="align: right"]2%[/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD]Château Grandis[/TD]
[TD]Château Grandis[/TD]
[TD="align: right"]2011[/TD]
[TD="align: right"]€ 6.63[/TD]
[TD][/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[timthewineguy]

this is what I want to end up with

[TABLE="width: 1938"]
<colgroup><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col><col span="6"></colgroup><tbody>[TR]
[TD]Supplier[/TD]
[TD]Wine[/TD]
[TD]Vintage[/TD]
[TD]price[/TD]
[TD]Discount[/TD]
[TD]Case/Min Order[/TD]
[TD]a[/TD]
[TD]b[/TD]
[TD]c[/TD]
[TD]d[/TD]
[TD]e[/TD]
[TD]f[/TD]
[TD]g[/TD]
[TD]h[/TD]
[TD]i[/TD]
[TD]j[/TD]
[TD]k[/TD]
[TD]l[/TD]
[TD]m[/TD]
[TD]n[/TD]
[TD]o[/TD]
[TD]p[/TD]
[TD]q[/TD]
[TD]r[/TD]
[TD]s[/TD]
[TD]t[/TD]
[TD]u[/TD]
[TD]Totals[/TD]
[/TR]
[TR]
[TD]Alceño[/TD]
[TD]Sierra de Enmedio Sauvignon Blanc[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]€ 1.74[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]120[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]228[/TD]
[/TR]
[TR]
[TD]Alceño[/TD]
[TD]Sierra de Enmedio Rosado[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]€ 1.74[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]30[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]78[/TD]
[/TR]
[TR]
[TD]Alceño[/TD]
[TD]Sierra de Enmedio Monastrell[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]€ 1.74[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]108[/TD]
[/TR]
[TR]
[TD]Alceño[/TD]
[TD]Sierra de Enmedio Garnacha[/TD]
[TD="align: right"]2018[/TD]
[TD="align: right"]€ 1.74[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]108[/TD]
[/TR]
[TR]
[TD]Alceño[/TD]
[TD]Hilanda Organic Monastrell[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]€ 2.26[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]132[/TD]
[/TR]
[TR]
[TD]Alceño[/TD]
[TD]Hilanda Monastrell[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]€ 2.37[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD="align: right"]48[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48[/TD]
[/TR]
[TR]
[TD]Alceño[/TD]
[TD]Hilanda Termino de Arribe[/TD]
[TD="align: right"]2017[/TD]
[TD="align: right"]€ 3.11[/TD]
[TD="align: right"]3%[/TD]
[TD]6x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Château Sorbey[/TD]
[TD]Château Sorbey **PROMO** (usually 5€!)[/TD]
[TD="align: right"]2012[/TD]
[TD="align: right"]€ 3.32[/TD]
[TD]Promo[/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]24[/TD]
[TD][/TD]
[TD="align: right"]24[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60[/TD]
[/TR]
[TR]
[TD]Château Sorbey[/TD]
[TD]Château Sorbey (only 120 btls left!)[/TD]
[TD="align: right"]2010[/TD]
[TD="align: right"]€ 4.58[/TD]
[TD="align: right"]2%[/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]24[/TD]
[TD="align: right"]24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]84[/TD]
[/TR]
[TR]
[TD]Château Sorbey[/TD]
[TD]Château Sorbey Cv Expression[/TD]
[TD="align: right"]2014[/TD]
[TD="align: right"]€ 4.26[/TD]
[TD="align: right"]2%[/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]0[/TD]
[/TR]
[TR]
[TD]Château Grandis[/TD]
[TD]Château Grandis[/TD]
[TD="align: right"]2011[/TD]
[TD="align: right"]€ 6.63[/TD]
[TD][/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[/TR]
[TR]
[TD]Château Grandis[/TD]
[TD]Château Grandis[/TD]
[TD="align: right"]2010[/TD]
[TD="align: right"]€ 8.00[/TD]
[TD][/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD="align: right"]24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]24[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]60[/TD]
[TD][/TD]
[TD="align: right"]144[/TD]
[/TR]
[TR]
[TD]Château Haut-Barrail[/TD]
[TD]Les Tourelles de Barrail[/TD]
[TD="align: right"]2016[/TD]
[TD="align: right"]€ 4.21[/TD]
[TD="align: right"]3%[/TD]
[TD]12x75cl[/TD]
[TD][/TD]
[TD="align: right"]36[/TD]
[TD][/TD]
[TD="align: right"]12[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD="align: right"]48[/TD]
[/TR]
</tbody>[/TABLE]