Collect data from multiple sheets

Hi,

I've some problem trying to collect data form multiple sheets after rows (with additional information) are added.
Excel does not seem to want to bring the newly added rows with information with it to my "summary sheet" (see attachment).

Not really interested in using Pivot table.

Any suggestions?

Much appreciated.