It is so difficult to input data in excel ( not hard coded numbers but linking numbers)

Can anyone explain how to do that If I have the given information on the first sheet of excel i.e the data entry sheet.
How can I enter data on other sheets for different statements like trial balance, single, multiple step income statement, balance sheet, retained earnings, and post close trial

Is there a website that teaches it well according to accounting concepts... not the excel tutor...
Help
Thanks a lot

You can use Financial Link for Excel to load financial statements of companies.
More details about Financial Link here:

XlConsulting - Financial modelling, financial data in Excel - Content