I have a large database of customers with their contact details and address etc.
With the database the main thing we analyse is source of the customer and sales person it was given to.
I have separate sheets of which narrow the database down by source. Such as telephone lead, website lead etc.
At the moment i am currently entering the data into the main database sheet and then have to enter again on the lead source sheet.

Is there any formula for a sheet for example website sheet in which it will look up a column in the main database (lead source column) and pull everything single row of customer details that have came from the website.

I would ideally like this to just continuously do this every time i enter data into the main database it automatically gets added to its separate sheet.

Can anyone help please?