Copy Entire column from different sheet if the column header matches the name based on dropdown

[ssinha23]

Hello I am trying to create a dynamic chart.

I have created the dropdown list, based on the column header names. Now I have all the raw data in a different sheet.
What I need is, if I select "Item A" from the drop down, it should go an search for "Item A" column header in the raw data sheet, copy the entire column and paste in designated column of the new sheet.
Idea is that everytime I select a new item from the dropdown, this column should get refreshed based on the data copied from the raw data with reference to the matching column header.
I will be using this data to create the dynamic chart.
Thanks in advance for your help.

** PLease note - I have tried out the offset formula, but that seems not to be working as I need the chart in a different sheet from the raw data sheet. Also this raw data is huge. No of columns is fixed. The first column is the daily date, and then onwards the item numbers for each column header on that respective date. I have a macro enabled that will be everyday adding a new row of data for a new date and respective date entry. So the raw data refreshes on a daily basis.

 

[maabadi]

If your dropdown Cell is K1 & Your Data at A1:H10 then

Book1
	A	B	C	D	E	F	G	H	I	J	K	L
1	Header1	Header2	Header3	Header4	Header5	Header6	Header7	Header8			Header3
2	Item11	Item21	Item31	Item41	Item51	Item61	Item71	Item81			Item31
3	Item12	Item22	Item32	Item42	Item52	Item62	Item72	Item82			Item32
4	Item13	Item23	Item33	Item43	Item53	Item63	Item73	Item83			Item33
5	Item14	Item24	Item34	Item44	Item54	Item64	Item74	Item84			Item34
6	Item15	Item25	Item35	Item45	Item55	Item65	Item75	Item85			Item35
7	Item16	Item26	Item36	Item46	Item56	Item66	Item76	Item86			Item36
8	Item17	Item27	Item37	Item47	Item57	Item67	Item77	Item87			Item37
9	Item18	Item28	Item38	Item48	Item58	Item68	Item78	Item88			Item38
10	Item19	Item29	Item39	Item49	Item59	Item69	Item79	Item89			Item39
11
12
13
14
15
16
Sheet1

Cell Formulas
Range	Formula
B2:H10	B2	="Item" & RIGHT(A2,LEN(A2)-4)*1+10
K2:K12	K2	=IFERROR(INDEX($A$1:$H$10,ROW(),MATCH($K$1,$A$1:$H$1,0)),"")