Add a row each day to multiple tables


Hi i am looking at daily share price data. I can import a file each day of share prices. I want to build up a history of some shares so each day that I import all share data I want to add a date row to my history table for that share, lookup the price and record date and price. Does that make sense?