macro that copies text from Excel to Word adds ruby text toggles field codes finds text

I am working with Chinese text in Excel 97. I can paste it into Word (2007) and use the Asian phonetic guide to add ruby text. Then when I toggle field codes it would be possible to search for and extract the ruby text from the base and copy it back into the excel file in the column to the right of the original Chinese text. My column of text in Excel is B6:B39 so the ruby text should be copied to C6:C39 but in several sheets the bottom few cells of B6:B39 are empty, so the macro needs to be able to handle that possibility. Also I want the macro to loop through a specified number of sheets where the cells to be copied from and pasted to are always in the same ranges as given above.