Selecting column d from 100 spreadsheet from single workbook

[Mahendra007]

Hi , I have a workbook where I have 100 sheet

I want column D from all sheet in one sheet pasted next to other like sheet1 column d in a column sheet2 column d in b. Olumn and so on

[Yoshiro_Fujimori · Accepted solution]

@Mahendra007 

I tried with a workbook with 3 sheets as attached.

Please see if it works for your book with 100 sheets. I hope this helps.

Input Sheet 1

	A	B	C	D
1	110	120	130	140
2	111	121	131	141
3	112	122	132	142
4	113	123	133	143

Input Sheet 2

	A	B	C	D
1	210	220	230	240
2	211	221	231	241
3	212	222	232	242
4	213	223	233	243
5	214	224	234	244

Input Sheet 3

	A	B	C	D
1	310	320	330	340
2	311	321	331	341
3	312	322	332	342
4	313	323	333	343
5	314	324	334	344
6	315	325	335	345

Workflow

Output

RowNo	Sheet1	Sheet2	Sheet3
1	140	240	340
2	141	241	341
3	142	242	342
4	143	243	343
5		244	344
6			345