I have a workbook with 8 worksheets. I have a "main summary" page that I have
manually input data. What I would like to do next is to "auto"
fill in data from "main summary" to other worksheets. For example I have a
cell with the text "Egypt" in J3, I would like all information of that row
be filled into sheet 2 which has headings. I have the same "format" on each
worksheet and I would like to set up each worksheet to fill in text with the
same text from sheet 1 to the sheet it needs to go to?