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]

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

<colgroup><col><col><col span="2"><col><col span="7"></colgroup><tbody>
</tbody>

 

[timthewineguy]

this is what I want to end up with

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

<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>
</tbody>