Hi all,

So my issue is one that I have seen many variables of, however, I cannot seem to find one that is specific to my needs. I am using Excel 2010 and am setting up a sales spreadsheet. I Have 4 sheets that I am using for this. I need columns A - F on sheet three (3) to copy the text from columns a - f on sheet one (1). Same with sheets 4 & 2. For instance, column A in sheet 1 is "Business Name". This column will grow indefinitely as we get more clients. I need column A in sheet 3 to copy any text added to any cells in sheet 1s A column. In which case, I could essentially type in the Business name in Sheet-1 cell-A2 and it will respectively show up in sheet3 cell-A2. automatically. and so on through A40, A150, etc. etc.

Any and all assistance is greatly appreciated!