I've been asked to create 25 lists and sub-sites for each department in my organization and then roll all those 25 lists into 1 master list.
I'm currently using SharePoint 2010 Standard. I don't have server access. The lists use lookups and I tried creating a template of the first list and recreating in a subsite but got an error about broken columns and all my lookups broke in the form.
Is this a bad idea or is there a better way to do this?