I have multiple spreadsheets that I want to move certain information from to
get all my info into one spreadsheet. Is there anyway to search mutiple
spreadsheets by a column like "Area" and tell it to retrive another
multiple colums like "Sport", "venue", "day", "date" etc then post it into a
corresponding column in another
worksheet by matching "Area"??
also information input into seperate spread sheets should also update the
spreadsheet with merged ino?