Making multipule changes

Originally Posted by Frazzfreeman

OK that would work but it would be just as quick to input the data if its only 1 cell's worth. What if there were 5, 10 or even 15 different cell's worth of info to input????

(In answer to your question; In my actual worksheets i have several other tabs with different information but they all use the same database)

If you have data suppose in range A1:G50 in one sheet and you want to link it to other sheet (or workbook), in other workbook select the same range i-e A1:G50 and press = and point your mouse to cell A1 of first sheet (where the original data is) then press CTRL+ENTER.
All cells of second sheet will be linked to original sheet.

Hope this helps.