Dear Paul,

Thank you for your reply and MY SINCEREST APOLOGIES for not thanking you sooner - my job sends me from pillar to post and I got very sidetracked from this task... I'm going to look at your suggestion further, which I believe will be a great starting point. With regards your questions though (and if you're still happy to help me...):

1/ Documents are all in different folders in the same network drive
2/ Headings are always the same and always constant
3/ Headings are always using Word's default Heading 1 Style
4/ Excel workbook already exists
5/ Upon opening the Excel workbook the code runs

The code would ideally perform the following way:

1/ Workbook is opened by user and code runs automatically
2/ Code looks at cell A1 in Sheet1, if A1 = TRUE then look at B1 (which is the cell that contains the file location e.g. S:\Clients\Client Name\Client Study\Filename.docx)
3/ Open File location
4/ Go to Heading Style 1 which is called "Summary"
5/ From next line below "Summary" copy all text until the next Heading Style 1 Named "Conclusion" - don't copy "Conclusion" and being able to copy formatting is a wish not a want
6/ Take copied text (no tables-just text but this can span over two pages but never more than this and should keep within Excel 2010 cell character limit ok)
7/ Go to adjacent cell to the Filename location in sheet1 - in this case C1
8/ Paste values (+ formatting if possible) into cell C1
9/ Go to next TRUE in column A and repeat above until last TRUE

*If possible a sort of where filename location is incorrect/doesn't exist then have the adjacent cell equal "Please check File Location" would be a super help

If you can think of any more questions I will respond asap. Many thanks for the help so far!

Kind regards,

Paul