Macro to Extract Data

[howard]

I would like a macro to extract data from the following workbooks excluding data from text "Total movement" onwards in Column A and data to the right of total movement onwards

for eg Br1 Parts Stock.8510145 , Br1 Parts stock.851162, Br1 Parts stock.851195 etc

The workbook will allways start with Br1 parts stock.

Once the data for the first workbook has been extracted, the data for the next workbook etc must be copied immediatekly after the last data for the previous workbook. for eg if the first workbook contains data in A1 to F600, then the next workbook must contain data from A600 onwards

I have listed the data below which must be excluded when extracting the data

Excel Workbook
	A	B	C	D	E
25	Total Movement	*	*	*	-12,437
26	*	*	*	*	*
27	Sales	*	*	*	-216,895
28	*	*	*	*	*
29	Purchases	*	*	*	243,183
30	*	*	*	*	*
31	Other	*	*	*	-38,725
32	*	*	*	*	*
33	Check	*	*	*	-12,437
34	*	*	*	*	*
Sheet1