filling the data from multiple cells into one column

hi

I have a sheet with 5 columns wherein unique serial numbers are filled in. I want to create another sheet where data from all these 5 columns get collaborated in column A on an ongoing basis. like once I fill in any value in any of these 5 columns, this value should automatically get filled in the last available cell of the another sheet column A. Please refer the enclosed sample workbook with sheets "Data" & "Result". In sheet Data, I fill the numbers and these numbers get collated in one column in sheet "result".

Is this possible at all ? if yes, please help.

Thanks.

Attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are demonstrated, mock them up manually if needed. Remember to desensitize the data.

Click on GO ADVANCED and use the paperclip icon to open the upload window.

View Pic