multible tabs

i have a sheet with multiple tabs, each tab is for one currency .
on daily basis i receive an excel sheet with the daily prices which i should fill the prices from the newsletter to my sheet .
is there anyway i can make it automatically take values from the newsletter to my sheet ?

my sheet