Copy/Migration Question

[nickolushenry]

Is it possible to add data to a list from other sheets as they are updated?

Example of what I am trying to do: 3 sheets total in a workbook. Main Sheet, Sheet2, Sheet 3

As data is added to Sheet2 and Sheet3 I would like that new added to be automatically copied to Main Sheet in a list format, as if it just adds to the next available row. So if A1 is already filled with data it will move onto B1.

Is this possible?

Thanks Excel guys and gals!!!

 

[stnkynts]

Please answer these questions.

Where would the data be added in Sheet 2 and Sheet 3?

Is Row 1 of the Main Sheet the only row that is populated or can you give a better reference than what you provided?

 

[nickolushenry]

Data will be compiled into Sheet2 & Sheet3, columns A & B

Would like the data then automatically copied/mirrored to MainSheet Column C & D, and the next available spot. Row 1 will be headers, everything else will be the copies/mirrored info from Sheet2 & 3.

Thanks!

 

[stnkynts]

I am still confused as to the orientation of your spreadsheet. Correct me if im wrong but you will be adding data into sheet2 and sheet3, both columns A & B, at each new row in that column. So for example their may be a time in which Sheet2 cell A305 may have data in it.

Do you enter data in one cell at a time, ex: Sheet2 Cell A5 one day and Sheet2 Cell B5 another day, or do you do each Row at a time, ex: Sheet2 Range A5:B5?

Each time you enter data into either Sheet2 or Sheet3 Column A or B it needs to populate Main Sheet Column C or D at the next available row?