same data multiple worksheets
 

I need to be able to have agencies type in a Consumer name and Agency name,
and have the data automatically fill in on the next page of the worksheet
same place for both. Please help, and explain so I can understand, I am not
an expert in Excel, or computer talk...