Excel create macros

We need help with one Excel spreadsheet with many tabs to prefill fields from first tab into other tabs.
Also a way to paste images into cells so they scale and be placed into correct position.