I want to type in certain cells on 5 different worksheets in one workbook;
and have that same data appear in 6 other workbooks. So I don't have to
retype or copy and paste the data in the other workbooks. Is there a way to
do this with a macro or some other linking feature in excel?

Hope this is clear thank you