I have the following code which copies data from one excel data entry
form (template) to another serving as master database. Is it possible
to alter this code so that the central database can be hosted on a server
on a network or across the internet and multiple users can post data to
it.

Workbooks.Open FileName:= _
"Macintosh HD:CompanyName:Forms:Data Entry
Forms:DatabaseBH.xls"
Sheets("Database").Select
ActiveSheet.ListObjects("List1").ListRows.Add Position:=1
Range("A2").Select
ActiveSheet.Paste
ActiveWorkbook.Save
ActiveWorkbook.Close

I've seen a post of a way to control access by writing a text file with the
user name on file open and deleting it on close. So I don't think
multiple access will be a problem with a small number of users.