Automatically copying new rows to another sheet

[paperheart]

Hello,

I have about 15 sheets with the same formatting and columns, but with different data like so:

People will be continually manually adding more and more entries to these 15 sheets. There are 2 things that need to be done automatically:

1. I would like to automatically copy and paste all old and new entries from these 15 sheets into a 'Master Sheet' with the same headings and format

2. I would like certain columns from 'Master Sheet' to be copied into a 'Data Input' sheet, without any formatting like so:

Any help would be greatly appreciated!!

Thanks.

 

[paperheart]

help please :D

 

[paperheart]

any ideas? is the explanation clear enough?

 

[paperheart]

bump

 

[Tej92]

this is exactly what i need, if you've come to a solution could you please share?
if not I'll share once i come to a solution.