Putting Out Colums from multiple Tabs

[kyleball]

Good Morning All!

I was wondering if anyone might be able to help. I did start completing it the only way I know how - which is really manual, and I realised it would take me some time.

Basically I have three excel workbooks; each contain multiple tabs. Within these tabs I would like to pull out three columns. On the whole for each individual workbook the columns are in the same position. However, within the same workbook they can change.

I was thinking of something that looks up the column title - this is something that does not change for each tab.

A typical individual tab would look like below; where I want to pull out the columns in red. This will allow me to compare the Reported to the Gross Actual to pick up any anomolied. The Asinfor is there just for reference in case it is needed.

Each tab has an individual name based on the name of the store. Thanks for any help that might be provided - and if I can provide further information do not hesitate to ask me of course!

Random	Asinfor	Random	Random	Random	Reported	Random	Gross Actual
	13000				14050		14050
	13500				13900		14000
	17000				18500		13000
	15050				16000		16500

<TBODY>
</TBODY>

 

[kyleball]

Oh, an example of what I am aiming to pull out into the new sheet is below; there would be about 20-30 for each of the three spreadsheets.

STORE NAME

<TBODY>
</TBODY>

Asinfor	Reported	Gross Actual	Difference
1350	1400	1400	0
1400	1500	1900	400
1300	1350	1000	-350
1200	1900	1500	-400

<TBODY>
</TBODY>

It would bring to attention any store which has reported sales of X, when we've actually received sales lower.

I guess I will use conditional formating on the difference (since the sales for each store can vary dramatically).

 

[kyleball]

Anyone?! Because I posted twice probably looks like someone replied and answered my request!